Typical SQL Optimization Methods

SQL optimization involves continuous analysis and adjustment. You need to test-run a query, locate and fix its performance issues (if any) based on its execution plan, and run it again, until the execution performance meet your requirements.

• SQL Self-Diagnosis
  
• Optimizing Statement Pushdown
  
• Optimizing Subqueries
  
• Optimizing Statistics
  
• Optimizing Operators
  
• Optimizing Data Skew