Home How to find out what is represented by the intermediate value used in SQL Server execution plan
Reply: 0

How to find out what is represented by the intermediate value used in SQL Server execution plan

user5965
1#
user5965 Published in September 19, 2018, 11:26 am

I'm learning how to read the actual execution plan in SQL Server. I have noticed that SQL Server tends to represent intermediate value used in the physical query plan as e.g. expr1006, expr1007 etc. (i.e. expr followed by a number).

Here is a screenshot. Notice near the bottom, the expressions expr1006, expr1008, expr1009 listed in the section output list.

It it possible to find out what they really represent?

share|improve this question
  • 1
    In addition to Martin Smith's answer below, there is a third party tool called SQL Sentry Plan Explorer (free download) which you can use to analyse your execution plans, there is a tab in it where you can view all the expressions used in the plan. – MJH Apr 15 at 14:02

1 Answer 1

active oldest votes
up vote 6 down vote accepted
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.396764 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO