The Query Optimizer

Oracle Database Performance Tuning Guide, 10g Release 2 (10.2).pdf

第十三章：The Query Optimizer

This chapter discusses SQL processing, optimization methods, and how the optimizer chooses a specific plan to execute SQL.

The chapter contains the following sections:

1. Optimizer Operations
2. Choosing an Optimizer Goal
3. Enabling and Controlling Query Optimizer Features
4. Understanding the Query Optimizer
5. Understanding Access Paths for the Query Optimizer
6. Understanding Joins

     本章主要讨论SQL的处理，优化方法和优化器如何为SQL选择一个特殊的执行计划，主要包括以下几个部分：

1. 优化器的操作
2. 选择优化器的目标
3. 启用和控制查询优化器的特性
4. 理解查询优化器r
5. 理解查询优化器的访问路径
6. 理解连接