What is RULE-based approach to optimization ?
Answer / 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 |
What are the differences between char and nchar in oracle?
What are the advantages of Views ?
Explain self joins in oracle?
What is an oracle data file?
Give the Types of modules in a form?
How do I manually uninstall oracle client?
Explain oracle’s system global area (sga).
Can we create database in oracle using command line ?
What is oracle join syntax?
what is the output of select * from emp where null=null & select * from emp where 1=1
What is format trigger?
How to create lov dynamically at runtime & attach to text field?