Cost Based Optimizer and Rule Based Optimizer

What is the difference between Cost Based Optimizer and Rule Based Optimizer?
(CBO is the default optimizer)

Questions by Pragati.rch

Showing Answers 1 - 3 of 3 Answers

ajay.ocp

  • Aug 20th, 2008
 

In brief the rule-based method means that when executing a query the database must follow certain predefined rules and matter what data is stored in affected database tables. The cost-based method means the database must decide which query execution plan to choose using best guess approach that takes into account what data is stored in db.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions