Create an index

sql

CREATE INDEX idx_notes_user_id_created_at ON notes (user_id, created_at DESC);

Explanation

A compact way to speed up per-user timelines or history screens.

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

Index a computed expression used in the query.

Open In sheetsqlsame section

Index only matching rows.

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