How can you check whether a MySQL query is making use of a Covering Index?

Question

How can you check whether a MySQL query is making use of a Covering Index and getting all the data it needs solely from that Index?

score 1 · Accepted Answer · answered Apr 26 '13 at 08:12

1

For an index only scan (covering index) MySQL shows 'Using index' in the Extra column.

answered Apr 26 '13 at 08:12

Markus Winand

1 Answers1