One of the challenges of the DBA’s role is to evaluate the changes they make to code or data structures on a busy, production system. While tuning a single query in isolation offers easy metrics such as elapsed time or logical reads, making minor tweaks on a busy system may require deeper evaluation.

Learning objectives:

At the end of this module, you'll be able to:

  • Describe wait statistics
  • Understand important aspects when tuning indexes
  • Explore when to use query hints