Sample Header Ad - 728x90

how to tell which statistics SQL server references in query

3 votes
0 answers
48 views
Is there a way to check in SQL Server 2016 which statistics the optimizer referenced when compiling a particular query? My question is similar to https://dba.stackexchange.com/questions/48890/how-to-check-what-stats-were-used-in-query , except that I am using SQL Server 2016, which doesn't appear to support trace flags 9204 and 9292 as listed in How to Find the Statistics Used to Compile an Execution Plan by Paul White. I tried them and nothing showed in my SSMS. I googled to check why - and it sounded as if 2016 doesn't support them?
Asked by user1430949 (265 rep)
Sep 12, 2017, 05:43 PM
Last activity: May 13, 2020, 01:52 AM