DB Index Strategy

Overview

Use this skill to choose indexes that improve real workloads while controlling write and storage costs.

Scope Boundaries

• Query latency hotspots are driven by access-path inefficiency.
• New query patterns or sort requirements are introduced.
• Existing indexes show redundancy, bloat, or unstable plans.

Core Judgments

• Query-path priority by business impact and frequency.
• Composite key order by filter selectivity and sort usage.
• Covering/partial/functional index suitability by engine capability.
• Write amplification and maintenance cost tolerance.