sql-optimization

Universal SQL performance optimization across MySQL, PostgreSQL, SQL Server, Oracle, and other databases. 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. Focus on measurable performance improvements and always test optimizations with realistic data volumes and query patterns. - Covers query analysis, index strategy design, subquery optimization, and JOIN tuning with before/after examples for each technique - Addresses common anti-patterns including SELECT *, function calls in WHERE clauses, inefficient pagination, and correlated subqueries - Provides database-agnostic guidance on batch operations, temporary tables, covering indexes, and partial indexes - Includes performance monitoring queries tailored to MySQL, PostgreSQL, and SQL Server for identifying slow queries and execution plan analysis - Features a universal optimization checklist spanning query structure, indexing, schema design, and testing methodology - Identify : Use database-specific tools to find slow queries - Analyze : Examine execution plans and identify bottlenecks - Optimize : Apply appropriate optimization techniques - Test : Verify performance improvements - Monitor : Continuously track performance metrics - Iterate : Regular performance...