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 Check which statistics were used in query optimization, 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?
