Databases Reference
In-Depth Information
7
Improving the
Oracle Optimizer
In this chapter, we will cover:
F
Exploring optimizer hints
F
Collecting statistics
F
Using histograms
F
Managing stored outlines
F
Introducing Adaptive Cursor Sharing for bind variable peeking
F
Creating SQL Tuning Sets
F
Using the SQL Tuning Advisor
F
Configuring and using SQL Baselines
Introduction
In this chapter, we discuss the query optimizer, which is a built-in component of the Oracle
database. The optimizer chooses the most efficient way to execute a SQL statement, using
three steps:
1.
Query transformation.
2.
Estimation.
3.
Plan generation.