Answer Posted / anil kumar abbireddy
1.Cost based Optimization (CBO)
2.Rule Based Optimization (RBO)
Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
What is sql clause?
Can we insert in sql function?
Define overloaded procedure?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What are the most important ddl statements in sql?
What are types of exception?
explain commit and rollback in mysql : sql dba
What is out parameter used for eventhough return statement can also be used in pl/sql?
what is a constraint? Tell me about its various levels. : Sql dba
what are the limitations of identity column? : Transact sql
how can we find the number of rows in a table using mysql? : Sql dba
Mention what are the benefits of pl/sql packages?
What is substitution variable?
Why do we use %rowtype & %type in plsql?
explain the difference between delete , truncate and drop commands? : Sql dba