Lets say I have a Table Ta with an index with 3 fields.
F1, F2, F3
I use a web based interface to create the index by selecting the table then selecting the fields in the index. So I don't know what 'order' the index is in.
I can run a 'show create table' statement and it shows them in oder of:
F2, F3, F1
When I query this table I want to use this index. I query (or join this table with another using the index).
I want to 'walk down the index' because it should be faster. But is this so with MySQL?? Does the Order I hit then index matter? If so, why doesn't my web based interface allow me to determine the order of the fields in the index?