1.Cost based Optimization (CBO) 2.Rule Based Optimization (RBO)

Types of optimization?

Question Posted / anil kumar abbireddy

Answer Posted / anil kumar abbireddy

1.Cost based Optimization (CBO)
2.Rule Based Optimization (RBO)

Is This Answer Correct ?

19 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can a select statement fire a trigger?

1159

What is sql server and ase?

1022

What is the difference between subquery and correlated query?

1065

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

What is %rowtype in pl sql?

989

What packages(if any) has oracle provided for use by developers?

5811

What are the events on which a database trigger can be based?

1189

What are different types of functions in sql?

1004

What are all the different normalization?

1037

What is pivot query?

1071

What are the 3 modes of parameter?

1154

What are the types of index in sql?

1069

what is the stuff function and how does it differ from the replace function? : Sql dba

1053

Define a temp table?

1017

How to Declare Fixed Length String Value In PL SQL

1155