Update enables XML Showplans to provide a list of statistics used during query optimization in SQL Server 2016 and 2017

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core


In SQL Server 2016 and 2017, the execution plan (showplan XML) now maintains a list of all the statistics that are loaded during query optimization under Cardinality Estimation (CE) version 120 or later. This is the same statistics information that is already exposed in the query_optimizer_estimate_cardinality xEvent.

More information

This improvement is included in the following cumulative update and SQL Server for SQL Server:

       Cumulative Update 3 for SQL Server 2017

Service pack information for SQL Server 2016

       Service Pack 2 for SQL Server 2016


Learn about the terminology Microsoft uses to describe software updates.