I've just started to investigating how I should optimize my database. Indexing seems to be a good idea, so I want to index a VARCHAR column, the engine is MyISAM.
From what I've read, I understand that an index is limited to a
size of 1000 bytes. A VARCHAR character is 3 bytes in
size. Does this mean that if I want to index a VARCHAR column
…