Cardinality Estimation for Multiple Predicates This is an off-site link.  Please review our Terms of Service for additional information.

(Paul White) Estimating the number of rows qualified by a single query predicate is often straightforward. When a predicate makes a simple comparison between a column and a scalar value, the chances are good that the cardinality estimator will be able to derive a good quality estimate from the statistics histogram.

Read this article...

comments powered by Disqus