Oracle Rule Based Optimizer (RBO)
Versions prior to 10.10

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
 
Access paths and their ranking
Path 1 Single Row by Rowid
Path 2 Single Row by Cluster Join
Path 3 Single Row by Hash Cluster key with Unique or Primary Key
Path 4 Single Row by Unique or Primary Key
Path 5 Clustered Join
Path 6 Hash Cluster Key
Path 7 Indexed Cluster Key
Path 8 Composite Index
Path 9 Single-Column Index
Path 10 Bounded Range Search on Indexed Columns
Path 11 Unbounded Range Search on Indexed Columns
Path 12 Sort-Merge Join
Path 13 MAX or MIN of Indexed Column
Path 14 ORDER BY on Indexed Column
Path 15 Full Table Scan

Related Topics
Tuning

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved