Oracle Rule Based Optimizer (RBO)
Versions prior to 10.1.0

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Be sure to view the full listing of monographs in Morgan's Library
 
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
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx