How do database indexes work and how do you choose the right indexes?

Indexes speed up reads by allowing the DB to avoid full table scans. **Indexing tips:** - Index columns used in WHERE/JOIN/ORDER BY - Use composite indexes based on query patterns - Consider selectivity (high-cardinality columns help more) - Avoid over-indexing (slower writes, more storage) Always verify with EXPLAIN/ANALYZE and measure before/after.