SQLskills Insider Session 8: Understanding Statistics - the Histogram
One of the most important aspects to estimation and optimization is the histogram component of statistics. In this demo-heavy session, we’ll look at multiple histograms and discuss the information stored and how SQL Server uses it for optimization. We’ll also talk about some of the reasons for why SQL Server limits the histogram to 200 (well, really 201) steps and how you can get around it (for some specific use cases).
START TIME: 10:00am Pacific Time / 1:00pm Eastern Time (what time for you?)
LENGTH: 75 minute session + 15 minute Q&A
Kimberly L. Tripp
President and Founder, SQLskills
Read my full bio here: Kimberly L. Tripp and about my Celebrating 25 Years of SQLskills here: https://www.sqlskills.com/about/meet-the-team/celebrating25years/
Join ONLY for Session 8
If you’ve already signed up for ALL SQLskills Insider Sessions, you’ll receive information about how to join each session and a 2 hour reminder.
If you’d prefer to sign up for only individual sessions, you can sign up for Session 8: Understanding Statistics here: