EXPLAIN SELECT * FROM Document INNER JOIN DocumentOwner ON DocumentOwner.OwnerID=Document.DocOwnerID AND DocumentOwner.CompanyID=Document.CompanyID WHERE Document.CompanyID=1 AND Document.Description > '5' AND DocumentOwner.Description LIKE 'Description%' ORDER BY Document.DocID DESC LIMIT 2 ; SELECT * FROM Document INNER JOIN DocumentOwner ON DocumentOwner.OwnerID=Document.DocOwnerID AND DocumentOwner.CompanyID=Document.CompanyID WHERE Document.CompanyID=1 AND Document.Description > '5' AND DocumentOwner.Description LIKE 'Description%' ORDER BY Document.DocID DESC LIMIT 2 ; -- CREATE INDEX BadIndex ON Document (DocOwnerID); ANALYZE TABLE Document; -- DROP INDEX BadIndex ON Document; ANALYZE TABLE Document;