by Dean Savović | 11:03 am

Here is a good reference to look at when having problems with cardinality estimation. You can also see differences between SQL Server 2012 and 2014 and usage scenarios of various trace flags.

Also, finally SQL Server 2014/2016 has improved cardinality estimation for multiple predicates.

Read more: http://www.sqlperformance.com/2014/01/sql-plan/cardinality-estimation-for-multiple-predicates.

Comments

No comments yet...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Shares