Query Performance Tuning

Lesson
Materials

As part of this section, we will go through basic performance tuning techniques with respect to queries.

  • Preparing Database

  • Interpreting Explain Plans

  • Overview of Cost Based Optimizer

  • Performance Tuning using Indexes

  • Criteria for indexes

  • Criteria for Partitioning

  • Writing Queries – Partition Pruning

  • Overview of Query Hints