In this post we continue looking at the Cardinality Estimator (CE). The article explores some join estimation algorithms in the details, however this is not a comprehensive join estimation analysis, the goal of this article is to give a reader a flavor of join estimation in SQL Server.
Pingback: SQL Server Дайджест #11: SQL Server 2016, Joins Internals, WWI Sample Database - LIKELY.CLUB