Design table partitioning strategies for large datasets
Design a partitioning strategy for: Database: [PostgreSQL/MySQL] Table to Partition: ```sql [PASTE TABLE SCHEMA] ``` Current Size: [ROWS/GB] Growth Rate: [DAILY/MONTHLY GROWTH] Retention Policy: [HOW LONG TO KEEP DATA] Query Patterns: [DESCRIBE COMMON QUERIES AND THEIR FILTERS] Please provide: 1. Partition type…
Premium Prompt
Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.
Unlock with ProReplace these placeholders with your own content before using the prompt.
[PASTE TABLE SCHEMA][HOW LONG TO KEEP DATA][DESCRIBE COMMON QUERIES AND THEIR FILTERS]