GeezerVison

The World Wide Web, restored to 800 pixels of glory.

GeezerVison is showing queryplan.dev — Free SQLite query plan visualizer | QueryPlan

Examples

lower(email) makes SQLite scan the customers table.

PostgreSQL and MySQL use different plan terms and may choose different work, but the same questions about scans, searches and sorts still apply.

Enter CREATE TABLE, CREATE INDEX, and optional INSERT statements.

Schema and sample data

10 lines

Loading SQL editor…

Query

Loading SQL editor…

Query plan

lower(email) changes the value SQLite compares, so it cannot use idx_customers_email and reads every customer instead. Choose Direct index lookup to compare.

Query result

1 row

Query result: 1 row
id	name
1	Ada Lovelace

Learn to read the plan

Read a query execution plan
Understand covering indexes
Use SQLite EXPLAIN QUERY PLAN

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.