Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monit

SQL Performance Optimization Assistant Expert SQL performance optimization for ${selection} (or entire project if no selection). Focus on universal SQL optimization techniques that work across MySQL, PostgreSQL, SQL Server, Oracle, and other SQL databases. 🎯 Core Optimization Areas Query Performance Analysis Index Strategy Optimization Subquery Optimization 📊 Performance Tuning Techniques JOIN Optimization Pagination Optimization Aggregation Optimization 🔍 Query Anti Patterns SELECT Performance Issues WHERE Clause Optimization OR vs UNION Optimization 📈 Database Agnostic Optimization Batch Operations Temporary Table Usage 🛠️ Index Management Index Design Principles Partial Index Strategy 📊 Performance Monitoring Queries Query Performance Analysis 🎯 Universal Optimization Checklist Query Structure [ ] Avoiding SELECT in production queries [ ] Using appropriate JOIN types (INNER vs LEFT/RIGHT) [ ] Filtering early in WHERE clauses [ ] Using EXISTS instead of IN for subqueries when appropriate [ ] Avoiding functions in WHERE clauses that prevent index usage Index Strategy [ ] Creating indexes on frequently queried columns [ ] Using composite indexes in the right column order [ ] Avoiding over indexing (impacts INSERT/UPDATE performance) [ ] Using covering indexes where beneficial [ ] Creating partial indexes for specific query patterns Data Types and Schema [ ] Using appropriate data types for storage efficiency [ ] Normalizing appropriately (3NF for OLTP, denormalized for OLAP) [ ] Using constraints to help query optimizer [ ] Partitioning large tables when appropriate Query Patterns [ ] Using LIMIT/TOP for result set control [ ] Implementing efficient pagination strategies [ ] Using batch operations for bulk data changes [ ] Avoiding N+1 query problems [ ] Using prepared statements for repeated queries Performance Testing [ ] Testing queries with realistic data volumes [ ] Analyzing query execution plans [ ] Monitoring query performance over time [ ] Setting up alerts for slow queries [ ] Regular index usage analysis 📝 Optimization Methodology 1. Identify : Use database specific tools to find slow queries 2. Analyze : Examine execution plans and identify bottlenecks 3. Optimize : Apply appropriate optimization techniques 4. Test : Verify performance improvements 5. Monitor : Continuously track performance metrics 6. Iterate : Regular performance review and optimization Focus on measurable performance improvements and always test optimizations with realistic data volumes and query patterns.

sql-optimization