Database Partitioning Strategy

Design a partitioning strategy for this table:

**Table Schema:**
```sql
{{TABLE_SCHEMA}}
```

**Data Characteristics:**
- Volume: {{DATA_VOLUME}}
- Growth Rate: {{GROWTH_RATE}}
- Date Range: {{DATE_RANGE}}
- Access Patterns: {{ACCESS_PATTERNS}}

**Database System:** {{DATABASE_SYSTEM}}
**Primary Objectives:** {{OBJECTIVES}}

Please provide:
1. Partitioning type recommendation (range, list, hash, composite)
2. Partition key selection with rationale
3. Partition definition SQL
4. Partition maintenance strategy:
   - Adding new partitions
   - Archiving old partitions
   - Rebalancing
5. Query optimization for partitioned tables
6. Index strategy for partitions
7. Backup and recovery considerations
8. Performance benchmarks to expect
9. Automation scripts