Create a basic index

sql

CREATE INDEX idx_posts_user_id ON posts(user_id);

Explanation

A simple index can dramatically reduce scan work on filters and joins.

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 multiple columns in query order.

Open In sheetsqlsame section

Enforce uniqueness and speed up lookups.

Open In sheetsqlsame section

Index only rows that match a predicate.

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