Partial index

sql

CREATE INDEX idx_tasks_open_due_at ON tasks (due_at) WHERE completed_at IS NULL;

Explanation

A smaller index can be more efficient when only open tasks matter to the hot path.

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 SQLite index creation

Add a basic lookup index.

Open In sheetsqlsame section

Index a computed expression used in the query.

Open In sheetsqlsame section

Inspect scans, searches, and covering-index use.

Open In sheetsql1 tag match

Populate or refresh planner statistics.

Open In sheetsql1 tag match

Ask the SQLite shell for index advice.

Open In sheetbash1 tag match