Scenario: Partition Key Choice for Orders at 10B Rows

orders grows by 80M/day. Most queries filter by created_at window and tenant_id. Choose partition key and justify.

orders(order_id, tenant_id, created_at, status, total_amount)