1. Index

To speed up queries, helps:

• WHERE
• JOIN
• ORDER BY
• GROUP BY

Trade-offs:

• Faster reads ✅
• Slower writes ❌
• Extra storage ❌

Types:

• B-Tree (default)
• Hash
• GIN (Postgres JSONB)

CREATE INDEX idx_users_email ON users(email);