Home > OS >  Show estimate vs actual estimations in query plan
Show estimate vs actual estimations in query plan

Time:09-26

For some reason my plans dont show an actual vs estimation in the designer query plan. I have seen these show on Brent Ozar videos. How do I get those to show?

enter image description here

CodePudding user response:

Keep up to date with SSMS releases for the best new features!

V18 introduced more granular information in the graphical execution plans including cumulative elapsed times for operators (or individual elapsed time for batch mode operators), actual vs estimated row counts, percentage of estimated rows read and various other goodies.

  • Related