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

How do we get field details of a table?

968


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

1006


How to execute a stored procedure in oracle?

1065


How to speed up webrick?

1054


Point the difference between translate and replace?

1067


Difference between open_form and call_form in oracle.

1132


Differentiate between translate and replace?

1079


Explain joins in oracle?

1021


How to change program global area (pga) in oracle?

1069


why dont we assign not null constraint as table level constraint.

2717


How to define a procedure inside another procedure?

998


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2211


What is a user account in oracle?

1103


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5503


How many types of synonyms in Oracle?

1102