Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 a proxy object?

1063


What is the use of oracle?

1030


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2144


How many data types are supported?

1079


What do you mean by a database transaction & what all tcl statements are available in oracle?

994


What is open database communication (odbc) in oracle?

1003


How to estimate disk space needed for an export job?

1051


Can you assign multiple query result rows to a variable?

988


How can we create the complete backup of data in the oracle.

2161


What are the differences between date and timestamp in oracle?

1046


How to drop a tablespace?

1044


How to increment dates by 1 in oracle?

1089


How to use "in out" parameter properly?

1048


How do I start tns listener?

1046


Explain the different normalization forms?

1103