The New Cardinality Estimator Changes
If you’ve upgraded to SQL Server 2014 and find that your queries are running more slowly than previously, it could actually be the new Cardinality Estimator. Changes in the cardinality estimates can result in a different query plan being chosen and it could end up being less efficient than the plan generated in a prior release.
If you suspect that the cause of the poor query optimization may be the result of the new Cardinality Estimator, the first step is to verify that it’s using the new Cardinality Estimator. Just because you are running SQL Server 2014 doesn’t mean that the new Cardinality Estimator is being used to optimize your queries. The database compatibility setting for the database context of ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
