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

What is data file?

619


What do you mean by merge in oracle?

593


What is a lookup table in oracle?

542


How to change system global area (sga) in oracle?

572


How to export data with a field delimiter?

582






What is an index associated with a constraint?

550


How to pass parameters to procedures in oracle?

570


How to sort the query output in oracle?

610


What is blob data type in oracle?

559


How to drop an existing view in oracle?

569


How to use regular expression in pattern match conditions in oracle?

575


Why do you use stored procedures and state some of its disadvantages?

563


What is a table index?

563


What are the arithmetic operations?

583


What is oracle host variable?

535