SQL Plan Explorer Missing Execution Mode
Is there some flag or option setting that needs to be set in Sentry Plan Explorer to show the Estimated/Actual Execution modes?
Thanks!
link text
These are also on tooltips in the graphical plan, for relevant operators. For example, a columnstore index scan:
If these data points are not there (you need to check both places), you can assume that they're both row. In the plan you added to your question, you are right, the tooltips for those operators do not show the execution mode, and I addressed those in the comment below. But if you look on the Plan Tree tab, you can see the batch mode operators if you add those two columns to the grid using the column chooser:
I typically run a query, and if trying to analyze or optimize it, I automatically move the execution plan over to Sentry Plan Explorer as the default analysis tool; I typically expect Sentry Plan Explorer to be the SSMS actual execution plan on steroids! LOL. We loved this tool so much we had purchased the "Pro" copies a while back. 🙂