Free Web Hosting by Netfirms
 Web Hosting by Netfirms | Free Domain Names by Netfirms

AmZone

A m Z o n e

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

    16. Press the Back button of you Browser to go to previous page
    Home