In a nutshell, I have a query that runs in 28 seconds until I perform a REPAIR TABLE against one of the tables in the query then execution time jumps to 51 seconds. The only way to get the query time back down is to TRUNCATE and repopulate the table. I've been operating under the assumption that REPAIR TABLE could only do good. Can someone elaborate on what's going on here?
This is the query in question: SELECT PeerQualifiedValueID, COUNT(*) AS Imps FROM MergedWaveImpression_3_4, CreativeValueFQ, Creative WHERE (MergedWaveImpression_3_4.CreativeID = CreativeValueFQ.CreativeID) AND (MergedWaveImpression_3_4.CreativeID = Creative.CreativeID) AND Creative.TemplateID = 8 GROUP BY PeerQualifiedValueID I thought I'd keep this post brief. I can post more information if needed. I'm running MySQL 4.0.12. Thanks! Lance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
