i noticed this on the mysql website: ---- I found that when EXPLAIN gives unexpected results (like using another index than the one you created especially for this goal), first running ANALYZE TABLE on the involved tables helped a lot. I put an ANALYZE TABLE for 10 or so "key" tables in the nightly cronjob for this reason. Especially useful if you mave more than one multi- key index on a table, or if tables can be joined along different paths. http://www.mysql.com/doc/en/EXPLAIN.html ----
i have many multi-key indices on one of my tables (5 such indices actually) and would like to know if i need to "ANALYZE" this table every night in a cron job etc? the above is just a comment on the Mysql website so am not sure how credible it is. would appreciate some advice. thanks .ep __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- 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
