Chapter 35. Understanding Query Optimization

by Ray Rankins

IN THIS CHAPTER

  • What Is a Query Optimizer?

  • Query Compilation and Optimization

  • Step 1: Query Analysis

  • Step 2: Index Selection

  • Step 3: Join Selection

  • Step 4: Execution Plan Selection

  • Reusing Query Plans

  • Other Query Processing Strategies

  • Parallel Query Processing

  • Data Warehousing and Large Database Query Strategies

  • Common Query Optimization Problems

  • Managing the Optimizer

Query optimization is the process SQL Server goes through to analyze individual queries and determine the best way to process them. To achieve this end, SQL Server uses a cost-based optimizer. As a cost-based optimizer, the optimizer's purpose is to determine the query plan that will access the data with the least amount of processing ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.