The SQL Server Query Optimizer is a cost-based Query Optimizer. For one specific query and tables, SQL Server creates the query plan based on the estimated rows. Hence, understanding how SQL Server calculate the estimated rows helps you troubleshoot query plan related issues.
I’m going to start a series of posts talking about SQL Server CE(Legacy/New).
The way that SQL Server calculates the estimated row of one single predicate is straightforward and simple.
Well, it becomes a little bit complex when SQL Server handles more than one predicates. Unlike the one single predicate, SQL Server has different strategies for