In this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS & AVG_RANGE_ROWS.
Keywords: Query Optimizer, Statistics, Histogram
Important Links:
|
Follow SQLMaestros on Twitter |
|
|
Follow Amit Bansal on Twitter |
|
|
Subscribe To Newsletter |
|
|
SQLMaestros Video Courses |
|
|
SQLMaestros Hands-On-Labs |
|
|
Subscribe to Amit Bansal’s exclusive distribution list |
|
|
Join us on Telegram |
Leave A Comment