SQL online course

Indexes

What an index is and when it is wasted.

An index is a separate structure that lets the engine find rows without scanning the table. Primary keys and unique constraints create indexes. You add more for columns that appear in WHERE, JOIN, and ORDER BY.

Indexes speed reads and slow writes. Do not index every column. Use EXPLAIN (or the vendor equivalent) before you argue about a query in a ticket.