SQLskills Insider Session 10: Statistics Wrap-Up + Q&A

We’ve spent two sessions talking about the histogram – how it’s used, how it’s built, and some of the concerns that stem from the fact that it has to be small to be effective (remember, the job of the optimizer is NOT to find the best plan but instead to find a good plan fast). As such, statistics (to be used QUICKL) must be small. And, they’re generally very good. However, there are definitely a few issues with large data sets or those that are very skewed. 

For this “statistics wrap” session, I’d love for you to go back over the resources of BOTH sessions 8 and session 9 and also watch the PASS session referenced (you can use Jan 5’s timeslot for that!). Then, please send me any remaining questions. I’ll also plan a few summary slides (as I did in the other Q&A) and then we’ll go from there.

  • SQLskills Insider Session #8: Understanding Statistics – The Histogram (details and download)
  • SQLskills Insider Session #9: Understanding Statistics – More on The Histogram (details, resources, references, and the scripts download)

SQLskills Insider Session #10: VIDEO

Return to our past sessions page here.

Session #10: Resources

Who knew… 3 two-hour sessions on the histogram / VLTs / and statistics internals… and, personally – I loved it! (and, many of you came back too – so cool!).

Resources for this SQLskills Insider Session: download

See our upcoming Insider Sessions here.

 

Presented by
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/