Loading...
Loading...
Search for a command to run...
Strategic denormalization for performance optimization
Advise on denormalization for this normalized schema:
**Current Schema:**
```sql
{{CURRENT_SCHEMA}}
```
**Performance Issues:**
{{PERFORMANCE_ISSUES}}
**Query Patterns:**
{{QUERY_PATTERNS}}
**Read/Write Ratio:** {{READ_WRITE_RATIO}}
**Database System:** {{DATABASE_SYSTEM}}
Please provide:
1. Analysis of current normalization level
2. Denormalization recommendations:
- Pre-computed columns
- Summary tables
- Duplicate columns for avoiding JOINs
3. Trade-off analysis for each recommendation
4. Data synchronization strategies
5. Trigger-based vs. application-based updates
6. Modified schema with denormalization
7. Query simplifications
8. Performance improvement estimates
9. Data consistency safeguardsOr press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
{{CURRENT_SCHEMA}{{PERFORMANCE_ISSUES}{{QUERY_PATTERNS}{{READ_WRITE_RATIO}{{DATABASE_SYSTEM}Copy this prompt and paste it into your favorite AI tool