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?
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.