Query Optimizer Additions in SQL Server 2016
In SQL Server 2016 we have introduced a number of new Query Optimizer improvements. This article summarizes some them and explains you can leverage the benefits of the new enhancements. Expect deep dive follow up articles for some of the enhancements. Here is the short list:
- Compatibility Level Guarantees
- Query Optimizer Improvements under Trace Flag 4199
- New Referential Integrity Operator
- Parallel Update of Sampled Statistics
- Sublinear Threshold for Update of Statistics
- Additions to the New Cardinality Estimator (New CE)
- Misc. Enhancements
For more details, please refer to my blog post below: