Which statistics-level is used by Plan()?

[MCMartin]

Is the Plan() function returning the result based on Optimizer estimates only? Is Plan() already executing the statement to gather the statistics?

[Former Member · Accepted solution]

Yes, Martin - if you use the PLAN() or EXPLANATION() functions, only optimizer estimates are included in the details for any specific plan operator.