- Sybase® SQL Server Performance and Tuning Guide
Chapter 7
The SQL Server Query Optimizer
- What Is Query Optimization?
- SQL Server's Cost-Based Optimizer
- Diagnostic Tools for Query Optimization
- Optimizer Strategies
- Search Arguments and Using Indexes
- Optimizing Joins
- Optimization of or clauses and in (values_list)
- Optimizing Aggregates
- Optimizing Subqueries
- Update Operations