Introduction
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