Design a complete, write-aware index set for a table or service based on its real query workload, eliminating redundancy and covering hot paths.
## CONTEXT I need a holistic indexing strategy for a table or a small set of related tables in 2026, not a one-off index for a single query. I will share the table DDL, the existing indexes, representative queries with their frequencies, and the read/write ratio. I want an index set that covers the hot read paths,…
Premium Prompt
Unlock this prompt — and all 25,000+ expert-crafted prompts — with Pro.
Unlock with Pro