Logistics of the Oracle Cost‐Based Optimizer (CBO)
Henry H. Liu · 2011
This chapter contains sections titled: Life of a SQL Statement in Oracle Oracle SQL Optimizer: Rule-Based versus Cost-Based CBO Statistics Pivot Role of Gathering Database Statistics to CBO Methods of Gathering CBO Statistics Locking and Unlocking CBO Statistics Explain Plan—A Handle to CBO Data Access Methods—CBO's Footprints Looking Up CBO's Plan Hidden in V$SQL_PLAN When CBO may Generate Suboptimum Execution Plans Summary Recommended Reading Exercises