0

I remember that I have seen somewhere in the past that when I saw the XML of the actual execution plan, it had the details about when the stats were updated on the indexes on a table and what was the number of rows sampled. I am not able to find that info now. Is there any knob that needs to be turned on or actual plan never had that kind of information in actual execution plan?

3

It is indeed in the execution plan, for those stats that were used.

There are two possible reasons why you don't see it:

  1. You use an older version of the database engine, where this info wasn't present in the XML.

  2. You use an older version of SSMS, which doesn't expose the info in the XML.

The answer to which of the above you have is by looking in the XML and see if the info is there. I'm on SQL Server 2019 and SSMS 18.5.

And you need to look at the right place, as well. You probably have to select the SELECT (outermost) operator, perhaps twice with something else in between, and view the Properties window:

enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.