mysql - What is a ideal column length to set while creating a BTREE index? -


i'm creating btree index large table data length of 1.5gb. ideal column length while creating btree index?

are talking index prefix length column? depends on data. if expect data unique after x characters, use x.


Comments