What is an INDEX?

Learn that an index speeds up search.

An INDEX speeds up searches. It acts like a table of contents in a book.

CREATE INDEX idx_name ON customers (name);

This query creates an index on the name column.

The index idx_name is created.

What is an INDEX? — details

An INDEX speeds up queries but slows down writes. Each INSERT/UPDATE also updates the index.

For example, on a site where users log in by email, indexing the email column makes a lookup among millions of rows almost instant.

Add an idx_name index on the name column of customers.

Show example solution

CREATE INDEX idx_name ON customers (name);

Add CREATE INDEX

CREATE ____ idx_name ON customers (name);

Show answer

CREATE INDEX idx_name ON customers (name);

Next lesson: CREATE INDEX