Typical SQL Optimization Methods

SQL tuning 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. This chapter describes common methods of SQL tuning.