Query Performance Tuning¶
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