Optimizer Directives

• Changes the generated query plan by removing paths from consideration

• Similar to Oracle’s HINTs

• Better than HINTs

  • More options
  • Cannot be ignored
  • Negative directives
  • Set Explain output

Previous slide

Next slide

Back to first slide

View graphic version