Rule Based Optimizer   «Prev  Next»

Lesson 1

SQL rule-based Optimizer

This module will describe the inner workings of the rule-based optimizer and provide you with a set of guidelines for determining when it is best to employ rule-based SQL optimization.
By the time you complete this module, you should be able to:
  1. Describe the major features of the rule-based optimizer
  2. List the advantages and disadvantages of the rule-based optimizer
  3. Correctly order table names in the FROM clause
  4. Correctly order items in the WHERE clause
  5. Rewrite complex Boolean logic with the UNION operator
  6. Evaluate and tune rule-based queries

Let us get started with an overview of rule-based optimization.