开发者

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…

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜