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