Search index

Speed up search with CREATE INDEX.

To speed up title search you add an index on the title column.

CREATE INDEX idx_title ON posts (title);

This query speeds up title searches.

The index idx_title is created.

Search index — details

An index speeds up search queries. It goes on frequently searched columns.

For example, WHERE title LIKE 'SQL%' benefits from an index on title, but searches starting with a wildcard such as '%SQL%' can't use it.

Add an idx_title index on title of posts.

Show example solution

CREATE INDEX idx_title ON posts (title);

Add CREATE INDEX

CREATE ____ idx_title ON posts (title);

Show answer

CREATE INDEX idx_title ON posts (title);