Create a composite index

sql

CREATE INDEX idx_posts_user_created_at ON posts(user_id, created_at DESC);

Explanation

Composite indexes work best when they match common WHERE and ORDER BY patterns.

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

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