Summary - INDEX

Speed up a search query with CREATE INDEX.

An INDEX speeds up searches and slows writes. Added with CREATE INDEX, removed with DROP INDEX.

CREATE INDEX idx_name ON customers (name);

Summary index query.

The index idx_name is created.

Exercise Summary - INDEX

Summary: add a name index on customers.

Show example solution

CREATE INDEX idx_name ON customers (name);

Next lesson: Blog design