I do all the optimizing work at my localhost, where I have SQL Trace Mode enabled. I've fixed quite a few SQL queries by adding extra indexes and limits, yet this one is persistant:
SELECT * FROM ibf_members_converge WHERE converge_email='dcoder1337@gmail.com' LIMIT 1
When it is executed, Trace mode fires a warning about requiring a full tablescan, phpMyAdmin > EXPLAIN says it can use an index and doesn't need a full tablescan. Which of them is correct and why the hell is such a conflict happening in the first place?
(Yes, there is an INDEX on the converge_email column.)