Create a unique index

sql

CREATE UNIQUE INDEX idx_users_email ON users(email);

Explanation

Useful both for integrity and for fast point lookups.

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

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