amar on web

• home
• On Oracle database
• On Oracle Forms&Reports
• On Oracle iAS
• On linux
• On PMP certification
• My blog
• My Profile
• family link

The Golden rankings of RBO

What are the ranking points on which the RBO works out the execution plan?
The Golden rankings in order of preference:

1. Single row by ROWID
2. Single row by cluster join
3. Single row by hash cluster with unique or primary key
4. Single row by unique or primary key
5. Cluster join
6. Hash cluster key
7. Indexed cluster key
8. Composite key
9. Single column indexes
10. Bounded range on index columns
11. Unbounded range on indexed columns
12. Sort merge join
13. MAX or MIN on indexed column
14. ORDER BY on indexed columns
15. FULL TABLE SCAN

Rule based optimizer (RBO) is desupported from Oracle release 10g, only the "rule" hint is available for backward compatibility.
Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was create on 15-dec-2000 and last updated on 31-dec-2006.
please forward all queries to amar_padhi@fastmail.fm