SQLite 3 · Pragmas and maintenance

See a query plan

Show whether a query uses an index.

EXPLAIN QUERY PLAN SELECT * FROM users WHERE email = '[email protected]';

Official SQLite 3 documentation

More pragmas and maintenance commands

All pragmas and maintenance commands · SQLite 3 cheatsheet

Was this page helpful?