800 million rows, partitioned by submission month (24 partitions, 2 years of history) - **MEMBER** — 45 million rows, partitioned by state code (50 partitions) - **PROVIDER** — 2 million rows, not partitioned - **PAYMENT** — 600 million rows, partitioned by payment date (24 partitions)