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 we join 3 tables in sql?

1106

Is sqlexception checked or unchecked?

1008

What is java sql drivermanager?

1159

How to use distinct and count in sql query? Explain

1080

Is not null in sql?

1042

How long will it take to learn pl sql?

979

Does sap use sql?

1039

What is the use of function in sql?

1147

How does join work in sql?

1051

What is group by in sql?

1124

What is rename in sql?

1017

What are the types of index in sql?

1118

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2609

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1062

how to check myisam tables for errors? : Sql dba

1389