Understanding SQL Server’s Cardinality Estimator for Better Query Performance When it comes to optimizing query performance in SQL Server, the Cardinality Estimator (CE) is a critical component that has a significant impact on how the Query Optimizer makes decisions for