Thomas Chiverton wrote: > On Thursday 17 Jul 2003 13:46 pm, Jochem van Dieten wrote: > >>cron + REINDEX takes care of that for BTREE indexes, but RTREE, Hash and >>GIST indexes don't need reindexing. (This was fixed for BTREE indexes in >>CVS 2 months ago so once 7.4 is released it will be completely gone.) > > :nods > Trouble was there was no *sure* way to know why a query was running slowly.
EXPLAIN ANALYZE will tell you exactly. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4