SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query plans in both OLTP and data warehousing solutions. The cardinality of a field refers to the number of unique values that are populated in the table. Gender would be a low cardinality field. Storing the driver license number for each customer would be a high cardinality field. In SQL Server the cardinality estimator predicts the number of rows required for the query result. When a database is newly created in SQL Server 2014, the new cardinality estimator is enabled. However, if you upgrade you would need to run an Alter Database statement.
Alter Database db_name
Set Compatibility_Level = 120
The post SQL Server 2014 Cardinality Estimator appeared first on Derek E Wilson - Blog.