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.
|
correct ..
explain will show you which indexes are used ..
this is a VERY GOOD book that everybody should read before starting the next project:
http://www.oreilly.com/catalog/hpmysql/index.html