Choose and design a partitioning or sharding strategy for a large, growing table with concrete keys, pruning, and maintenance plans.
## CONTEXT I have a large and growing table in 2026 that is straining single-table performance, maintenance windows, or retention management. I will share the table DDL, row counts and growth rate, the dominant query predicates, and my retention rules. I want a clear recommendation on whether and how to partition…
Premium Prompt
Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.
Unlock with Pro