Quote:
Originally posted by phpslave
also note that if you key on two or more items example (id, name, date), you should select in that order as well in order to use these indexes correctly, or so i was told at mysql training, lol.
you can do a desc then your statement in the client to see how your using the indexes and in which order the preformance is best.
|
nice tip, as it makes sense as you move down the row.
I use EXPLAIN on the queries to see how good/bad they are.