I'm trying to find performance issues on query which is based on other queries etc.
I found that I have a union query which is slow, but I have no idea which union query/column it is.
All I get in the execution plan are nodes like:
<SeekPredicates> <SeekPredicateNew> <SeekKeys> <Prefix ScanType="EQ"> <RangeColumns> <ColumnReference Database="[mydb]" Schema="[dbo]" Table="[Sales]" Column="SaleID" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="[Union1399]"> <Identifier> <ColumnReference Column="Union1399" /> </Identifier> </ScalarOperator> </RangeExpressions> </Prefix> </SeekKeys> </SeekPredicateNew> </SeekPredicates>
How can I know which fields/tables make up this "union1399"? So can index it or remove it or otherwise optimize the query.