Enable automatic EXPLAIN QUERY PLAN in shell

text

.eqp on

Explanation

Handy during interactive tuning sessions in the sqlite3 shell.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Inspect query plans

See whether SQLite scans or uses an index.

Open In sheetsqlsame section

Help the planner choose better indexes.

Open In sheetsqlsame section

Recreate indexes when needed.

Open In sheetsqlsame section

Let SQLite perform lightweight maintenance.

Open In sheetsqlsame section

Index a frequently filtered column.

Index multiple columns in query order.