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 an oracle?

1063


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

1071


What is an anonymous block?

1319


Differentiate between translate and replace?

1184


How does the on-delete-cascade statement work?

1158


How to write text literals in oracle?

1117


What is the usage of merge statement?

1200


 What are the oracle DML commands possible through an update strategy?

1101


What is oracle host variable?

1124


What is a dead lock in oracle?

1175


What are nested tables?

1219


What is the data pump import utility?

1071


How to define a variable to match a table column data type?

1029


What are the limitations of check constraint?

1071


Where is the export dump file located?

1218