performance benefits using BINARY vs CHAR. Round 2: VARBINARY vs VARCHAR
is it true that there are performance benefits (in inserting, comparing, etc) when using the BINARY compared to CHAR?
Similarly, VARBINARY is more performant than VA开发者_C百科RCHAR data types??
CHAR(datatype)
is more performance than VARCHAR
.
Atomic datatype is more performance because it is indexable.
Always use char, varchar when store text data because you can use like, concat,etc operation on varchar(datatype) or char(datatype).
Always use BINARY(fixed)
, VARBINARY(var)
when store binary data such as image, file, etc…
精彩评论