Partition Design

Concepts: paPartitioning

What They Want to Hear 'I start from query patterns, not data structure. Which columns appear in WHERE clauses? What is the data volume per partition? Is there skew?' Then walk through: 'For this use case, I would partition by date because 90% of queries filter on date range. Each daily partition holds ~500 MB, which is the sweet spot. If one customer generates 80% of events, I would add hash bucketing within partitions to distribute evenly.'