What is an optimizer ?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is an optimizer ?
Rating:
An optimizer is an Oracle process that determines the best plan for executing a statement. The optimizer uses built-in rules and cost methods for determining the best plan. The Oracle server uses two optimization methods:
- Cost-based optimization
- Rule-based optimization
In the rule-based optimization method, the Oracle server uses some predefined rules for selecting the execution plan. The optimizer uses the rule-based approach if there are no statistics present in the data dictionary for any of the accessed objects.
Rating:
Was this information helpful?
Other articles
- What is quiesced state?
- What are index-organized tables (IOT)?
- Things to practice for Oracle test 1Z0-033.
- What is process spinning and sleeping?
- What is DML?