In rule base optimization we use the Query to tune,but in cost base optimization we use the data retrieved by the query.

Anurag Kehri

• Jan 10th, 2006

Oracle having two mode of optimization.1.Rule Based Optimizer(RBO).2.Cost Based Optimization(CBO).RBO is syntex driven,it uses basically a some kind of ranking system(20 condition ranking rule),c...

Answer Question  Select Best Answer