SQL · Schema and constraints

index

Speeds up matching reads at the cost of writes and storage. Index the columns you filter and join on.

sqlRunnable example sql course

Syntax

create index name on table(col);

Example

Open in the lab

CREATE TABLE lessons (course TEXT);
CREATE INDEX lessons_course_idx ON lessons(course);
SELECT name FROM sqlite_master WHERE type = 'index' AND name = 'lessons_course_idx';

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

index

Example

More in this group

Learn this in the course