What is RULE-based approach to optimization ?

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


Please Help Members By Posting Answers For Below Questions

How to create a new tablespace in oracle?

744


What operating systems are supported by oracle database 10g xe?

795


How many types of tables supported by oracle?

790


What is PL/SQL ?

1382


How to create lov dynamically at runtime & attach to text field?

887


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1683


What happens to the current transaction if the session is ended?

807


How to get a list of all background sessions in the database?

742


How to assign values to data fields in record variables?

778


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

862


What is oracle server autotrace in oracle?

858


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1651


What is the minimum client footprint required to connect c# to an oracle database?

783


How to connect ms access to oracle servers?

730


Is oracle a language?

697