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

What are the types of join in sql?

1151

What does the acronym acid stand for in database management?

1091

Explian rowid, rownum?

1086

What is the difference between database trigger and stored procedure?

1141

What do you understand by pl/sql packages?

1108

What is the difference between null value, zero, and blank space?

1257

Is sqlite thread safe?

1102

How to fix oracle error ora-00942: table or view does not exist

1084

What are expressions?

1062

What is sqlca in db2?

1038

what are the advantages and disadvantages of views in a database? : Sql dba

1075

Is a foreign key always unique?

984

What are the features of pl sql?

1112

what is the difference between clustered and non clustered index in sql? : Sql dba

1192

Is it possible to update views?

1007