Module 8: Performance Tuning and Optimization
As your data grows from thousands to millions or billions of rows, simple queries that once took milliseconds can start taking minutes. In this module, you will go “under the hood” of the database engine to understand how it finds data and how you can guide it to work more efficiently.
Learning Objectives
Section titled “Learning Objectives”In this module, you will:
- Understand the mechanics of B-Tree and Hash indexes.
- Learn the difference between Clustered and Non-Clustered indexes.
- Interpret Execution Plans to identify bottlenecks like Table Scans.
- Master SARGability to ensure your filters are index-friendly.
- Apply high-performance coding patterns to reduce CPU and I/O usage.
Chapters
Section titled “Chapters” 8.1 Indexing How B-Tree and Hash indexes work and when to use them.
8.2 Execution Plans Reading the Query Planner to identify bottlenecks.
8.3 SARGability Writing 'Search ARGument Able' queries for index usage.
8.4 Optimization Best Practices Avoiding SELECT * and other high-performance patterns.