SQL Server 2014 New Features: Cardinality Estimation in the Query Optimizer
May 25,
2015
Is it Better or Worse? What is Cardinality Estimation A fancy-sounding phrase, “cardinality estimation” basically means “guessing how many”. The ability of the query optimizer to select a superior query plan from among many possibilities requires the estimation of how many rows will be extracted from the participating tables and how these rows will be […]