Index Design

Strategic indexing for query performance without write overhead.

Context

You are deciding which indexes to create. Index every query path, but don't overdo it.

Domain Context

• B-tree: Default; works for most queries
• Composite: Multiple columns; order matters for range queries
• Covering: Includes all columns query needs; avoids table lookup
• Unique: Enforce uniqueness; sometimes performance benefit
• Tradeoff: Faster reads, slower writes, more storage

Instructions