Back to VisualizerSQL Explain Example
mysql

MySQL Covering Index

Query satisfied entirely by the index (Using index).

SELECT email FROM users WHERE active = 1;

"Using index" (without "Using where") means all required columns were found in the index itself, avoiding a table heap lookup. This is known as a Covering Index.

Interactive Execution Plan

EXPLAIN Output
Run: EXPLAIN FORMAT=JSON your_query; or EXPLAIN your_query;
Enter SQL EXPLAIN output to visualizeSupports PostgreSQL EXPLAIN ANALYZE, MySQL EXPLAIN, and SQLite EXPLAIN QUERY PLAN formats