Product has been added to your cart.

08 – Estimates vs Actuals (48m)

Generally, when a query plan operator’s estimated number of rows is vaguely similar to the actual number of rows, SQL Server had a pretty good idea of how much work would be required for that part of the query, and it built an appropriate plan. It may not be a fast plan – for example, maybe…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.

Generally, when a query plan operator’s estimated number of rows is vaguely similar to the actual number of rows, SQL Server had a pretty good idea of how much work would be required for that part of the query, and it built an appropriate plan. It may not be a fast plan – for example, maybe...
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.