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
In the following two simple single table examples we see the use of the PRIMARY key. To the untrained eye this may lead to assume that the right index is being used.