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

user523
1#
user523 Published in July 17, 2018, 7:26 pm

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?

You need to login account before you can post.

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

© 2016 Powered by mzan.com design MATCHINFO