Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different optimizers that are used to optimize database?
- 1 Answers
- 9 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is new feature in oracle asm 12c?
How would you identify the shared_pool_size parameter that needs to be adjusted?
What are the key characteristics of rac or why to use rac?
How can a single instance environment be converted into rac environment and how will they be different?
How is rman better than user-managed backup recovery process?
Mention what is cluster?
What are the components required to manage oracle real application clusters database?
How is incremental backup different from differential backup?
How would you differentiate between cluster and grid?
What are the provisions and resources provided in the oracle’s cloud server?
What is the function of having virtual internet protocol address (vip) in oracle rac?
How can we collect the statistics of different database objects?
Oracle General 
