This question already has an answer here:
- MySQL - varchar length and performance 2 answers
I have a
VARCHAR(255) primary field field in an
InnoDB database table. I only store values of length 32 bytes in it (32 ASCII characters). My primary key has a prefix length of 767 bytes. Clearly, this longer prefix length than I need. Does this have any performance impact?