While preparing the post about Adaptive Joins, I’d like to share a quick post about the hidden gem in SQL Server 2017 CTP 2.0, discovered recently. In this short post, we will look at how you can determine what statistics are used by the optimizer during a plan compilation in SQL Server 2017.
Tag Archives: statistics
Cardinality Estimation Concepts
In this blog post we are going to talk about the principles and the main concepts which are used by the optimizer to perform an estimation.
Read…