Rebuild indexes

sql

REINDEX;

Explanation

Useful after collation changes or when rebuilding index structures.

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

Let SQLite perform lightweight maintenance.

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