Run PRAGMA optimize

sql

PRAGMA optimize;

Explanation

A low-cost maintenance step you can run periodically in long-lived applications.

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

Show plans before each entered statement.

Open In sheettextsame section

Index a frequently filtered column.

Open In sheetsql1 tag match

Index multiple columns in query order.

Open In sheetsql1 tag match