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

Whether any commands are used for months calculation? If so, what are they?

1040


How to define a cusotmer as a supplier in ORACLE R12

2169


Explain the use of log option in exp command.

1046


What is Java Pool in Oracle?

1090


What is connection pooling in oracle?

911


Can we protect our pl/sql source code?

992


How to define an anonymous block?

1072


What is not equal to in oracle?

952


How to create a new user account in oracle?

953


1) Does oracle have any table which contain all the exceptions and it's code internally?

1696


How many types of table in Oracle?

1059


Is truncate autocommit in oracle?

1020


What are the uses of synonyms?

1083


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2151


How to filter out duplications in the returning rows using oracle?

989