Answer Posted / kalyani
Rule Based Optimizer (RBO) - This method is used if the
server has no internal statistics relating to the objects
referenced by the statement. This method is no longer
favoured by Oracle and will be desupported in future
releases
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is an oracle?
Why do you use stored procedures and state some of its disadvantages?
What is an anonymous block?
Differentiate between translate and replace?
How does the on-delete-cascade statement work?
How to write text literals in oracle?
What is the usage of merge statement?
 What are the oracle DML commands possible through an update strategy?
What is oracle host variable?
What is a dead lock in oracle?
What are nested tables?
What is the data pump import utility?
How to define a variable to match a table column data type?
What are the limitations of check constraint?
Where is the export dump file located?