Cardinality Estimation (SQL Server) [!INCLUDE SQL Server Azure SQL Database] The [!INCLUDE ssNoVersion] Query Optimizer is a cost-based Query Optimizer. This means that it selects query plans that ...

Cardinality estimation is widely believed to be one of the most important causes of poor query plans. Prior studies evaluate the impact of cardinality estimation on plan quality on a set of ...