Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: (OT) Don't blow that index dude.

by tinita (Parson)
on Nov 29, 2005 at 12:08 UTC ( [id://512599] : note . print w/replies, xml ) Need Help??

in reply to (OT) Don't blow that index dude.

been there, done that =)

i find the EXPLAIN function in mysql extremely helpful as it can show you which index it will use.
also, with USING (indexname) you can force mysql to use a specific index if it isn't clever enough to find it out by itself. don't know, which DBMS you're working on.