Indexing and Performance Tuning in MySQL

Create Index

CREATE INDEX idx_salary ON employees(salary);

Usage

Indexes help WHERE, JOIN, ORDER BY. But avoid too many indexes on large INSERT/UPDATE tables.