What is Database Index?
A lookup structure that makes queries fast — at a small write cost.
An auxiliary structure (usually a B-tree) the database keeps sorted for fast lookups on a column, turning a full table scan into a targeted seek. Indexes speed reads but slow writes and take space, so they're added deliberately based on real queries.
CREATE INDEX idx_users_email ON users(email);