SQL Server Indexing, Statistics, and Parameter Sniffing

Solving Optimization Challenges with Indexes

Your browser needs to be JavaScript capable to view this video

Try reloading this page, or reviewing your browser settings

This video segment discusses specific slow queries and walks through the process of creating or modifying indexes to improve performance. Covering indexes are also introduced as a way to manage latency via key lookups.

Keywords

  • Indexing
  • Performance Optimization
  • Query Tuning

About this video

Author(s)
Edward Pollack
First online
29 January 2020
DOI
https://doi.org/10.1007/978-1-4842-5727-2_2
Online ISBN
978-1-4842-5727-2
Publisher
Apress
Copyright information
© Ed Pollack 2020