sql-optimization

原文涵盖的主题

• SQL Performance Optimization Assistant
• 🎯 Core Optimization Areas
• Query Performance Analysis
• Index Strategy Optimization
• Subquery Optimization
• 📊 Performance Tuning Techniques
• JOIN Optimization
• Pagination Optimization

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. [ ] 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 [ ] 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 [ ] 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 [ ] 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 [ ] Testin

这里只展示节选，请以完整原文和当前要求为准。