عرض عملي: تقسيم سجل الطلبات حسب الشهر

خطوة بخطوة

1. Show the unpartitioned 10 M-row orders and the plan for a one-month query (large index or sequential scan).
2. Create the partitioned table orders_p with a composite primary key and monthly partitions plus a default partition.
3. Copy data in batches and add indexes; swap names in a short transaction.
4. Run the one-month query: EXPLAIN shows only one partition scanned (pruning).
5. Planned mistake: filter with a function on created_at, so pruning does not happen. Fix: use a direct range.
6. DETACH PARTITION orders_2025_01 and archive; compare with the old bulk DELETE.

Prepares MID-019-LAB1.

اختبر فهمك