> -----Original Message----- > From: Mike Wexler [mailto:[EMAIL PROTECTED]]
> The best answer is, "try it and see." If your tables are > small. Adding > and removing indices is very quick. And testing queries is > also very quick. Enabling the slow query log, and enabling log-long-format can give some hints by logging all queries that don't use indexes. Then you can feed those queries to the EXPLAIN command and figure out why. I dramatically sped up several queries on my database this way. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php