CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Rule Based Optimizer (RBO)
Prior to Version 10.1
 
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
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [54 users online]    © 2010 psoug.org