Create a partial index

sql

CREATE INDEX idx_sessions_active ON sessions(user_id)
WHERE revoked_at IS NULL;

Explanation

Partial indexes can be smaller and more selective than indexing the entire table.

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 Create and use indexes

Index a frequently filtered column.

Open In sheetsqlsame section

Index multiple columns in query order.

Open In sheetsqlsame section

Enforce uniqueness and speed up lookups.

Open In sheetsqlsame section

See whether SQLite scans or uses an index.

Open In sheetsql1 tag match

Help the planner choose better indexes.

Open In sheetsql1 tag match

Recreate indexes when needed.

Open In sheetsql1 tag match