Understanding when EXPLAIN is not using an index as intended

(Ronald Bradford) When reading a MySQL Query Execution Plan (QEP) produced by the EXPLAIN command, generally one of the first observations is to validate an index is being used per table (i.e. per row of output). In MySQL, this is observed with the key column.

Read More - Register for Free Membership