Index

CREATE INDEX index_name ON table_name (column1, column2, ...);

CREATE INDEX idx_last_name ON employees (last_name);

An index is used to speed up the retrieval of rows by using a pointer.

Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows.