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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle RAC
  2. Suggest New Category

What are the different optimizers that are used to optimize database?

Question Posted / Shyam Ji Mishra

Answer Posted / Shyam Ji Mishra

Oracle Database uses two main optimizers: 1. SQL Query Optimizer: It's responsible for selecting the most efficient execution plan for a given SQL statement. 2. Rules-Based Optimization (RBO): This allows you to specify hints to influence the optimization process. 3. Cost-Based Optimization (CBO): This is the default optimizer that chooses the optimal execution path based on the statistics collected from the database objects.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category