Quote:
|
setting right indexes can improve performance significantly .. using wrong indexes will reduce it ..
|
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.