Back to VisualizerSQL Explain Example
sqlite

SQLite Covering Index

Covering index scan in SQLite.

SELECT Title FROM albums WHERE AlbumId > 100;

COVERING INDEX means SQLite retrieved all necessary data from the index b-tree without accessing the main table (rowid lookup skipped).

Interactive Execution Plan

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