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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial