Skip to content
  • Training
  • Consulting
  • First Responder Kit
  • Blog
    • Popular Topics
    • Well, Actually...
  • Videos
  • Log In
Newsletter

04. Multi-Column Statistics and the Cardinality Estimators (14m)

In the real world, your indexes often cover multiple columns. We’ll see how the density vector has multiple rows now, and see how the pre-2014 and 2014+ cardinality estimator have huge differences.

[wpc_button]

03. Combining Multiple Single-Column Statistics (8m) 05. What Is the Cardinality Estimator? (5m)

In this class

Statistics: SQL Server’s Guessing Game
  • 01. A Tale of Two Plans (7m)
  • 02. Getting to Know Statistics (15m)
  • 03. Combining Multiple Single-Column Statistics (8m)
  • 04. Multi-Column Statistics and the Cardinality Estimators (14m)
  • 05. What Is the Cardinality Estimator? (5m)
  • 06. Filtered Statistics: ENHANCE! (15m)
  • 07. The Ascending Key Problem (11m)
  • 08. 10 Rules for Managing Statistics (12m)
  • 09. Seeks, Scans, and Sargability (9m)
  • 10. How Execution Plans are Made (10m)

SQL Server training, consulting, and thousands of pages of free help.

Get the newsletter

Training

  • Live classes
  • Recorded classes
  • Corporate training
  • Log In

Free Help

  • First Responder Kit
  • Blog
  • Videos
  • Newsletter

Company

  • Consulting
  • About
  • Contact
© Brent Ozar Unlimited®. All rights reserved. · Privacy