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

if you ctreate table identity

2428


What is a table index in oracle?

1185


What is the difference between Delete, Truncate and Drop in Oracle?

1185


Is oracle an operator?

983


What is recycle bin in Oracle?

1197


What are the differences between number and binary_float in oracle?

1149


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2547


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894


What is different types of joins?

1078


What are the predefined tablespaces in a database?

1141


What are the limitations oracle database 10g xe?

1093


Explain the difference between sql and oracle?

1126


How to save query output to a local file?

1084


How many types of table in Oracle?

1172


What are the ways tablespaces can be managed and how do they differ?

2445