Understanding Indexes in MySQL

Example

CREATE INDEX idx_salary ON employees(salary);

SHOW INDEX FROM employees;

Too many indexes can slow down INSERT/UPDATE operations.