Advertisement
Guest User

Untitled

a guest
Apr 19th, 2016
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 191.89 KB | None | 0 0
  1. <?xml version="1.0" encoding="utf-16"?><ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="12.0.4427.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="declare Variable1 as date&#xD;&#xA;set Variable1 = Function1(Column1, ?, Function2());&#xD;&#xA;" StatementId="1" StatementCompId="1" StatementType="ASSIGN" RetrievedFromCache="false" /><StmtSimple StatementText="declare Variable2 as nvarchar(7)&#xD;&#xA;set Variable2 = LEFT(Variable1, ?) + ? + RIGHT(LEFT(Variable1, ?), ?);&#xD;&#xA;" StatementId="2" StatementCompId="2" StatementType="ASSIGN" RetrievedFromCache="false" /><StmtSimple StatementText="declare Variable3 as nvarchar(30)&#xD;&#xA;set Variable3 = ?;&#xD;&#xA;&#xD;&#xA;" StatementId="3" StatementCompId="3" StatementType="ASSIGN" RetrievedFromCache="false" /><StmtSimple StatementText="Statement1" StatementId="4" StatementCompId="4" StatementType="SELECT" RetrievedFromCache="false" StatementSubTreeCost="18.2581" StatementEstRows="1.0225" StatementOptmLevel="FULL" QueryHash="0xC8F4D45F9FD51E24" QueryPlanHash="0xF48F2C7040AAF11D" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" /><QueryPlan CachedPlanSize="720" CompileTime="228" CompileCPU="228" CompileMemory="11808"><MissingIndexes><MissingIndexGroup Impact="31.5132"><MissingIndex Database="Database1" Schema="Schema1" Table="Object1"><ColumnGroup Usage="EQUALITY"><Column Name="Column22" ColumnId="8" /></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="Column23" ColumnId="5" /><Column Name="Column2" ColumnId="6" /><Column Name="Column27" ColumnId="7" /><Column Name="Column21" ColumnId="11" /><Column Name="Column9" ColumnId="12" /><Column Name="Column10" ColumnId="13" /><Column Name="Column11" ColumnId="14" /><Column Name="Column12" ColumnId="15" /><Column Name="Column17" ColumnId="21" /></ColumnGroup></MissingIndex></MissingIndexGroup><MissingIndexGroup Impact="31.4689"><MissingIndex Database="Database1" Schema="Schema1" Table="Object1"><ColumnGroup Usage="EQUALITY"><Column Name="Column22" ColumnId="8" /></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="Column23" ColumnId="5" /><Column Name="Column2" ColumnId="6" /><Column Name="Column27" ColumnId="7" /><Column Name="Column24" ColumnId="9" /><Column Name="Column21" ColumnId="11" /><Column Name="Column25" ColumnId="22" /></ColumnGroup></MissingIndex></MissingIndexGroup><MissingIndexGroup Impact="32.8799"><MissingIndex Database="Database1" Schema="Schema1" Table="Object1"><ColumnGroup Usage="EQUALITY"><Column Name="Column23" ColumnId="5" /><Column Name="Column2" ColumnId="6" /><Column Name="Column24" ColumnId="9" /></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="Column27" ColumnId="7" /><Column Name="Column22" ColumnId="8" /><Column Name="Column21" ColumnId="11" /><Column Name="Column9" ColumnId="12" /><Column Name="Column10" ColumnId="13" /><Column Name="Column11" ColumnId="14" /><Column Name="Column12" ColumnId="15" /><Column Name="Column13" ColumnId="16" /><Column Name="Column14" ColumnId="18" /><Column Name="Column15" ColumnId="19" /><Column Name="Column16" ColumnId="20" /><Column Name="Column17" ColumnId="21" /><Column Name="Column18" ColumnId="23" /><Column Name="Column19" ColumnId="24" /><Column Name="Column20" ColumnId="25" /></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(12),[SD].[SnapshotDate_Key],0)" /><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(12),[SD].[SnapshotDate_Key],0)" /><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(varchar(12),[SD].[SnapshotDate_Key],0)" /><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(varchar(12),[SD].[SnapshotDate_Key],0)&gt;='201604'" /></Warnings><MemoryGrantInfo SerialRequiredMemory="2688" SerialDesiredMemory="3008" /><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="358400" EstimatedPagesCached="179200" EstimatedAvailableDegreeOfParallelism="4" /><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.0225e-007" AvgRowSize="248" EstimatedTotalSubtreeCost="18.2581" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1100" /><ColumnReference Column="Expr1101" /><ColumnReference Column="Expr1102" /><ColumnReference Column="Expr1103" /><ColumnReference Column="Expr1104" /><ColumnReference Column="Expr1105" /><ColumnReference Column="Expr1106" /><ColumnReference Column="Expr1107" /><ColumnReference Column="Expr1108" /><ColumnReference Column="Expr1109" /><ColumnReference Column="Expr1110" /><ColumnReference Column="Expr1111" /><ColumnReference Column="Expr1112" /><ColumnReference Column="Expr1113" /><ColumnReference Column="Expr1114" /><ColumnReference Column="Expr1115" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1115" /><ScalarOperator ScalarString="ScalarString1"><Const ConstValue="Value1" /></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.12475e-006" AvgRowSize="146" EstimatedTotalSubtreeCost="18.2581" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1100" /><ColumnReference Column="Expr1101" /><ColumnReference Column="Expr1102" /><ColumnReference Column="Expr1103" /><ColumnReference Column="Expr1104" /><ColumnReference Column="Expr1105" /><ColumnReference Column="Expr1106" /><ColumnReference Column="Expr1107" /><ColumnReference Column="Expr1108" /><ColumnReference Column="Expr1109" /><ColumnReference Column="Expr1110" /><ColumnReference Column="Expr1111" /><ColumnReference Column="Expr1112" /><ColumnReference Column="Expr1113" /><ColumnReference Column="Expr1114" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1103" /><ScalarOperator ScalarString="ScalarString2"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1479" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1480" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1104" /><ScalarOperator ScalarString="ScalarString3"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1481" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1482" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1105" /><ScalarOperator ScalarString="ScalarString4"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1483" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1484" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1106" /><ScalarOperator ScalarString="ScalarString5"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1485" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1486" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1107" /><ScalarOperator ScalarString="ScalarString6"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1487" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1488" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1108" /><ScalarOperator ScalarString="ScalarString7"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1489" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1490" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1109" /><ScalarOperator ScalarString="ScalarString8"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1491" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1492" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1110" /><ScalarOperator ScalarString="ScalarString9"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1493" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1494" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1111" /><ScalarOperator ScalarString="ScalarString10"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1495" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1496" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1112" /><ScalarOperator ScalarString="ScalarString11"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1497" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1498" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1113" /><ScalarOperator ScalarString="ScalarString12"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1499" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1500" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1114" /><ScalarOperator ScalarString="ScalarString13"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1501" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1502" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.12475e-006" AvgRowSize="146" EstimatedTotalSubtreeCost="18.2581" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1100" /><ColumnReference Column="Expr1101" /><ColumnReference Column="Expr1102" /><ColumnReference Column="Expr1479" /><ColumnReference Column="Expr1480" /><ColumnReference Column="Expr1481" /><ColumnReference Column="Expr1482" /><ColumnReference Column="Expr1483" /><ColumnReference Column="Expr1484" /><ColumnReference Column="Expr1485" /><ColumnReference Column="Expr1486" /><ColumnReference Column="Expr1487" /><ColumnReference Column="Expr1488" /><ColumnReference Column="Expr1489" /><ColumnReference Column="Expr1490" /><ColumnReference Column="Expr1491" /><ColumnReference Column="Expr1492" /><ColumnReference Column="Expr1493" /><ColumnReference Column="Expr1494" /><ColumnReference Column="Expr1495" /><ColumnReference Column="Expr1496" /><ColumnReference Column="Expr1497" /><ColumnReference Column="Expr1498" /><ColumnReference Column="Expr1499" /><ColumnReference Column="Expr1500" /><ColumnReference Column="Expr1501" /><ColumnReference Column="Expr1502" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1479" /><ScalarOperator ScalarString="ScalarString14"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1052" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1480" /><ScalarOperator ScalarString="ScalarString15"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1052" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1481" /><ScalarOperator ScalarString="ScalarString16"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1053" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1482" /><ScalarOperator ScalarString="ScalarString17"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1053" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1483" /><ScalarOperator ScalarString="ScalarString18"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1054" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1484" /><ScalarOperator ScalarString="ScalarString19"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1054" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1485" /><ScalarOperator ScalarString="ScalarString20"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1055" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1486" /><ScalarOperator ScalarString="ScalarString21"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1055" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1487" /><ScalarOperator ScalarString="ScalarString22"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1056" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1488" /><ScalarOperator ScalarString="ScalarString23"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1056" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1489" /><ScalarOperator ScalarString="ScalarString24"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1057" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1490" /><ScalarOperator ScalarString="ScalarString25"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1057" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1491" /><ScalarOperator ScalarString="ScalarString26"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1058" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1492" /><ScalarOperator ScalarString="ScalarString27"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1058" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1493" /><ScalarOperator ScalarString="ScalarString28"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1059" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1494" /><ScalarOperator ScalarString="ScalarString29"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1059" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1495" /><ScalarOperator ScalarString="ScalarString30"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1060" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1496" /><ScalarOperator ScalarString="ScalarString31"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1060" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1497" /><ScalarOperator ScalarString="ScalarString32"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1061" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1498" /><ScalarOperator ScalarString="ScalarString33"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1061" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1499" /><ScalarOperator ScalarString="ScalarString34"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1062" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1500" /><ScalarOperator ScalarString="ScalarString35"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1062" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1501" /><ScalarOperator ScalarString="ScalarString36"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1063" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1502" /><ScalarOperator ScalarString="ScalarString37"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1063" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1100" /><ColumnReference Column="Expr1101" /><ColumnReference Column="Expr1102" /></GroupBy><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1.0225" EstimateIO="0.0112613" EstimateCPU="0.000100197" AvgRowSize="146" EstimatedTotalSubtreeCost="18.2581" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Expr1100" /><ColumnReference Column="Expr1101" /><ColumnReference Column="Expr1102" /></OutputList><MemoryFractions Input="0.5" Output="1" /><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1100" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1101" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1102" /></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.0225e-007" AvgRowSize="146" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Expr1100" /><ColumnReference Column="Expr1101" /><ColumnReference Column="Expr1102" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1100" /><ScalarOperator ScalarString="ScalarString38"><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1080" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1081" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1082" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1083" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1101" /><ScalarOperator ScalarString="ScalarString39"><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1084" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1085" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1086" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1087" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1088" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1089" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1102" /><ScalarOperator ScalarString="ScalarString40"><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Expr1090" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1091" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1092" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1093" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1094" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1095" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1096" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1097" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1098" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1099" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.0225e-007" AvgRowSize="216" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Expr1080" /><ColumnReference Column="Expr1081" /><ColumnReference Column="Expr1082" /><ColumnReference Column="Expr1083" /><ColumnReference Column="Expr1084" /><ColumnReference Column="Expr1085" /><ColumnReference Column="Expr1086" /><ColumnReference Column="Expr1087" /><ColumnReference Column="Expr1088" /><ColumnReference Column="Expr1089" /><ColumnReference Column="Expr1090" /><ColumnReference Column="Expr1091" /><ColumnReference Column="Expr1092" /><ColumnReference Column="Expr1093" /><ColumnReference Column="Expr1094" /><ColumnReference Column="Expr1095" /><ColumnReference Column="Expr1096" /><ColumnReference Column="Expr1097" /><ColumnReference Column="Expr1098" /><ColumnReference Column="Expr1099" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1080" /><ScalarOperator ScalarString="ScalarString41"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1128" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1129" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1081" /><ScalarOperator ScalarString="ScalarString42"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1130" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1131" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1082" /><ScalarOperator ScalarString="ScalarString43"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1132" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1133" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1083" /><ScalarOperator ScalarString="ScalarString44"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1134" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1135" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1084" /><ScalarOperator ScalarString="ScalarString45"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1136" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1137" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1085" /><ScalarOperator ScalarString="ScalarString46"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1138" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1139" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1086" /><ScalarOperator ScalarString="ScalarString47"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1140" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1141" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1087" /><ScalarOperator ScalarString="ScalarString48"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1142" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1143" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1088" /><ScalarOperator ScalarString="ScalarString49"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1144" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1145" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1089" /><ScalarOperator ScalarString="ScalarString50"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1146" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1147" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1090" /><ScalarOperator ScalarString="ScalarString51"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1148" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1149" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1091" /><ScalarOperator ScalarString="ScalarString52"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1150" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1151" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1092" /><ScalarOperator ScalarString="ScalarString53"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1152" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1153" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1093" /><ScalarOperator ScalarString="ScalarString54"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1154" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1155" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1094" /><ScalarOperator ScalarString="ScalarString55"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1156" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1157" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1095" /><ScalarOperator ScalarString="ScalarString56"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1158" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1159" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1096" /><ScalarOperator ScalarString="ScalarString57"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1160" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1161" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1097" /><ScalarOperator ScalarString="ScalarString58"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1162" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1163" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1098" /><ScalarOperator ScalarString="ScalarString59"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1164" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1165" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1099" /><ScalarOperator ScalarString="ScalarString60"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1166" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1167" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="0" AvgRowSize="191" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Expr1128" /><ColumnReference Column="Expr1129" /><ColumnReference Column="Expr1130" /><ColumnReference Column="Expr1131" /><ColumnReference Column="Expr1132" /><ColumnReference Column="Expr1133" /><ColumnReference Column="Expr1134" /><ColumnReference Column="Expr1135" /><ColumnReference Column="Expr1136" /><ColumnReference Column="Expr1137" /><ColumnReference Column="Expr1138" /><ColumnReference Column="Expr1139" /><ColumnReference Column="Expr1140" /><ColumnReference Column="Expr1141" /><ColumnReference Column="Expr1142" /><ColumnReference Column="Expr1143" /><ColumnReference Column="Expr1144" /><ColumnReference Column="Expr1145" /><ColumnReference Column="Expr1146" /><ColumnReference Column="Expr1147" /><ColumnReference Column="Expr1148" /><ColumnReference Column="Expr1149" /><ColumnReference Column="Expr1150" /><ColumnReference Column="Expr1151" /><ColumnReference Column="Expr1152" /><ColumnReference Column="Expr1153" /><ColumnReference Column="Expr1154" /><ColumnReference Column="Expr1155" /><ColumnReference Column="Expr1156" /><ColumnReference Column="Expr1157" /><ColumnReference Column="Expr1158" /><ColumnReference Column="Expr1159" /><ColumnReference Column="Expr1160" /><ColumnReference Column="Expr1161" /><ColumnReference Column="Expr1162" /><ColumnReference Column="Expr1163" /><ColumnReference Column="Expr1164" /><ColumnReference Column="Expr1165" /><ColumnReference Column="Expr1166" /><ColumnReference Column="Expr1167" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1148" /><ScalarOperator ScalarString="ScalarString61"><Identifier><ColumnReference Column="Expr1128" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1149" /><ScalarOperator ScalarString="ScalarString62"><Identifier><ColumnReference Column="Expr1129" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1150" /><ScalarOperator ScalarString="ScalarString63"><Identifier><ColumnReference Column="Expr1130" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1151" /><ScalarOperator ScalarString="ScalarString64"><Identifier><ColumnReference Column="Expr1131" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1152" /><ScalarOperator ScalarString="ScalarString65"><Identifier><ColumnReference Column="Expr1132" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1153" /><ScalarOperator ScalarString="ScalarString66"><Identifier><ColumnReference Column="Expr1133" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1154" /><ScalarOperator ScalarString="ScalarString67"><Identifier><ColumnReference Column="Expr1134" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1155" /><ScalarOperator ScalarString="ScalarString68"><Identifier><ColumnReference Column="Expr1135" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1156" /><ScalarOperator ScalarString="ScalarString69"><Identifier><ColumnReference Column="Expr1136" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1157" /><ScalarOperator ScalarString="ScalarString70"><Identifier><ColumnReference Column="Expr1137" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1158" /><ScalarOperator ScalarString="ScalarString71"><Identifier><ColumnReference Column="Expr1138" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1159" /><ScalarOperator ScalarString="ScalarString72"><Identifier><ColumnReference Column="Expr1139" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1160" /><ScalarOperator ScalarString="ScalarString73"><Identifier><ColumnReference Column="Expr1140" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1161" /><ScalarOperator ScalarString="ScalarString74"><Identifier><ColumnReference Column="Expr1141" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1162" /><ScalarOperator ScalarString="ScalarString75"><Identifier><ColumnReference Column="Expr1142" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1163" /><ScalarOperator ScalarString="ScalarString76"><Identifier><ColumnReference Column="Expr1143" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1164" /><ScalarOperator ScalarString="ScalarString77"><Identifier><ColumnReference Column="Expr1144" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1165" /><ScalarOperator ScalarString="ScalarString78"><Identifier><ColumnReference Column="Expr1145" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1166" /><ScalarOperator ScalarString="ScalarString79"><Identifier><ColumnReference Column="Expr1146" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1167" /><ScalarOperator ScalarString="ScalarString80"><Identifier><ColumnReference Column="Expr1147" /></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="6.4213e-007" AvgRowSize="191" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Expr1128" /><ColumnReference Column="Expr1129" /><ColumnReference Column="Expr1130" /><ColumnReference Column="Expr1131" /><ColumnReference Column="Expr1132" /><ColumnReference Column="Expr1133" /><ColumnReference Column="Expr1134" /><ColumnReference Column="Expr1135" /><ColumnReference Column="Expr1136" /><ColumnReference Column="Expr1137" /><ColumnReference Column="Expr1138" /><ColumnReference Column="Expr1139" /><ColumnReference Column="Expr1140" /><ColumnReference Column="Expr1141" /><ColumnReference Column="Expr1142" /><ColumnReference Column="Expr1143" /><ColumnReference Column="Expr1144" /><ColumnReference Column="Expr1145" /><ColumnReference Column="Expr1146" /><ColumnReference Column="Expr1147" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1128" /><ScalarOperator ScalarString="ScalarString81"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1022" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1129" /><ScalarOperator ScalarString="ScalarString82"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1022" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1130" /><ScalarOperator ScalarString="ScalarString83"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1037" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1037" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1131" /><ScalarOperator ScalarString="ScalarString84"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1037" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1037" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1132" /><ScalarOperator ScalarString="ScalarString85"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1048" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1048" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1133" /><ScalarOperator ScalarString="ScalarString86"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1048" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1048" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1134" /><ScalarOperator ScalarString="ScalarString87"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1040" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1040" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1135" /><ScalarOperator ScalarString="ScalarString88"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1040" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1040" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1136" /><ScalarOperator ScalarString="ScalarString89"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1013" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1137" /><ScalarOperator ScalarString="ScalarString90"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1013" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1138" /><ScalarOperator ScalarString="ScalarString91"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1139" /><ScalarOperator ScalarString="ScalarString92"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1140" /><ScalarOperator ScalarString="ScalarString93"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1027" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1027" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1141" /><ScalarOperator ScalarString="ScalarString94"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1027" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1027" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1142" /><ScalarOperator ScalarString="ScalarString95"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1041" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1041" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1143" /><ScalarOperator ScalarString="ScalarString96"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1041" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1041" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1144" /><ScalarOperator ScalarString="ScalarString97"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1038" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1038" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1145" /><ScalarOperator ScalarString="ScalarString98"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1038" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1038" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1146" /><ScalarOperator ScalarString="ScalarString99"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1049" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1049" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1147" /><ScalarOperator ScalarString="ScalarString100"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1049" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1049" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ScalarOperator ScalarString="ScalarString101"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ScalarOperator ScalarString="ScalarString102"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ScalarOperator ScalarString="ScalarString103"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1052" /><ScalarOperator ScalarString="ScalarString104"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1052" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1053" /><ScalarOperator ScalarString="ScalarString105"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1053" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1054" /><ScalarOperator ScalarString="ScalarString106"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1054" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1055" /><ScalarOperator ScalarString="ScalarString107"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1055" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1056" /><ScalarOperator ScalarString="ScalarString108"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1056" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1057" /><ScalarOperator ScalarString="ScalarString109"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1057" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1058" /><ScalarOperator ScalarString="ScalarString110"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1058" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1059" /><ScalarOperator ScalarString="ScalarString111"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1059" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1060" /><ScalarOperator ScalarString="ScalarString112"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1060" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1061" /><ScalarOperator ScalarString="ScalarString113"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1061" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1062" /><ScalarOperator ScalarString="ScalarString114"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1062" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1063" /><ScalarOperator ScalarString="ScalarString115"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1063" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="Column5" /></GroupBy><RelOp NodeId="8" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="2.045" EstimateIO="0" EstimateCPU="2.24745e-006" AvgRowSize="191" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Column5" /><ColumnReference Column="Column6" /><ColumnReference Column="Column7" /></OutputList><WindowSpool><RelOp NodeId="9" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="0" AvgRowSize="191" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Column6" /><ColumnReference Column="Column7" /></OutputList><Segment><GroupBy><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></GroupBy><SegmentColumn><ColumnReference Column="Column7" /></SegmentColumn><RelOp NodeId="10" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="6.4213e-008" AvgRowSize="183" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /><ColumnReference Column="Column6" /></OutputList><Segment><GroupBy /><SegmentColumn><ColumnReference Column="Column6" /></SegmentColumn><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.12475e-006" AvgRowSize="175" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1052" /><ColumnReference Column="Expr1053" /><ColumnReference Column="Expr1054" /><ColumnReference Column="Expr1055" /><ColumnReference Column="Expr1056" /><ColumnReference Column="Expr1057" /><ColumnReference Column="Expr1058" /><ColumnReference Column="Expr1059" /><ColumnReference Column="Expr1060" /><ColumnReference Column="Expr1061" /><ColumnReference Column="Expr1062" /><ColumnReference Column="Expr1063" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1052" /><ScalarOperator ScalarString="ScalarString116"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1452" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1453" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1053" /><ScalarOperator ScalarString="ScalarString117"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1454" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1455" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1054" /><ScalarOperator ScalarString="ScalarString118"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1456" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1457" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1055" /><ScalarOperator ScalarString="ScalarString119"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1458" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1459" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1056" /><ScalarOperator ScalarString="ScalarString120"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1460" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1461" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1057" /><ScalarOperator ScalarString="ScalarString121"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1462" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1463" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1058" /><ScalarOperator ScalarString="ScalarString122"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1464" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1465" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1059" /><ScalarOperator ScalarString="ScalarString123"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1466" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1467" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1060" /><ScalarOperator ScalarString="ScalarString124"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1468" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1469" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1061" /><ScalarOperator ScalarString="ScalarString125"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1470" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1471" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1062" /><ScalarOperator ScalarString="ScalarString126"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1472" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1473" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1063" /><ScalarOperator ScalarString="ScalarString127"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1474" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1475" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.12475e-006" AvgRowSize="175" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1452" /><ColumnReference Column="Expr1453" /><ColumnReference Column="Expr1454" /><ColumnReference Column="Expr1455" /><ColumnReference Column="Expr1456" /><ColumnReference Column="Expr1457" /><ColumnReference Column="Expr1458" /><ColumnReference Column="Expr1459" /><ColumnReference Column="Expr1460" /><ColumnReference Column="Expr1461" /><ColumnReference Column="Expr1462" /><ColumnReference Column="Expr1463" /><ColumnReference Column="Expr1464" /><ColumnReference Column="Expr1465" /><ColumnReference Column="Expr1466" /><ColumnReference Column="Expr1467" /><ColumnReference Column="Expr1468" /><ColumnReference Column="Expr1469" /><ColumnReference Column="Expr1470" /><ColumnReference Column="Expr1471" /><ColumnReference Column="Expr1472" /><ColumnReference Column="Expr1473" /><ColumnReference Column="Expr1474" /><ColumnReference Column="Expr1475" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1452" /><ScalarOperator ScalarString="ScalarString89"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1013" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1453" /><ScalarOperator ScalarString="ScalarString90"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1013" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1454" /><ScalarOperator ScalarString="ScalarString128"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1014" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1455" /><ScalarOperator ScalarString="ScalarString129"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1014" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1456" /><ScalarOperator ScalarString="ScalarString130"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1015" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1457" /><ScalarOperator ScalarString="ScalarString131"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1015" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1458" /><ScalarOperator ScalarString="ScalarString132"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1459" /><ScalarOperator ScalarString="ScalarString133"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1460" /><ScalarOperator ScalarString="ScalarString134"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1017" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1461" /><ScalarOperator ScalarString="ScalarString135"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1017" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1462" /><ScalarOperator ScalarString="ScalarString136"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1018" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1463" /><ScalarOperator ScalarString="ScalarString137"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1018" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1464" /><ScalarOperator ScalarString="ScalarString138"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1019" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1465" /><ScalarOperator ScalarString="ScalarString139"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1019" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1466" /><ScalarOperator ScalarString="ScalarString140"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1020" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1467" /><ScalarOperator ScalarString="ScalarString141"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1020" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1468" /><ScalarOperator ScalarString="ScalarString142"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1469" /><ScalarOperator ScalarString="ScalarString143"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1470" /><ScalarOperator ScalarString="ScalarString144"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value4" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1471" /><ScalarOperator ScalarString="ScalarString145"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value4" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1472" /><ScalarOperator ScalarString="ScalarString146"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value5" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1473" /><ScalarOperator ScalarString="ScalarString147"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value5" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1474" /><ScalarOperator ScalarString="ScalarString148"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1026" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1475" /><ScalarOperator ScalarString="ScalarString149"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1026" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1023" /><ColumnReference Column="Expr1024" /><ColumnReference Column="Expr1015" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1017" /><ColumnReference Column="Expr1028" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1049" /></GroupBy><RelOp NodeId="14" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1.0225" EstimateIO="0.0112613" EstimateCPU="0.00010029" AvgRowSize="239" EstimatedTotalSubtreeCost="18.2468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1014" /><ColumnReference Column="Expr1015" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1017" /><ColumnReference Column="Expr1018" /><ColumnReference Column="Expr1019" /><ColumnReference Column="Expr1020" /><ColumnReference Column="Expr1021" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1023" /><ColumnReference Column="Expr1024" /><ColumnReference Column="Expr1026" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1028" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /></OutputList><MemoryFractions Input="0.1" Output="0.5" /><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1013" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1022" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1023" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1024" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1015" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1016" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1017" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1028" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1027" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1037" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1038" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1048" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1040" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1041" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1049" /></OrderByColumn></OrderBy><RelOp NodeId="15" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="1.0225e-007" AvgRowSize="239" EstimatedTotalSubtreeCost="18.2354" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1014" /><ColumnReference Column="Expr1015" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1017" /><ColumnReference Column="Expr1018" /><ColumnReference Column="Expr1019" /><ColumnReference Column="Expr1020" /><ColumnReference Column="Expr1021" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1023" /><ColumnReference Column="Expr1024" /><ColumnReference Column="Expr1026" /><ColumnReference Column="Expr1027" /><ColumnReference Column="Expr1028" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1046" /><ColumnReference Column="Expr1047" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1050" /><ColumnReference Column="Expr1051" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1027" /><ScalarOperator ScalarString="ScalarString150"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value5" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028" /><ScalarOperator ScalarString="ScalarString151"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value4" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1021" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1.0225" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="231" EstimatedTotalSubtreeCost="18.2354" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1014" /><ColumnReference Column="Expr1015" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1017" /><ColumnReference Column="Expr1018" /><ColumnReference Column="Expr1019" /><ColumnReference Column="Expr1020" /><ColumnReference Column="Expr1021" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1023" /><ColumnReference Column="Expr1024" /><ColumnReference Column="Expr1026" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1046" /><ColumnReference Column="Expr1047" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1050" /><ColumnReference Column="Expr1051" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OuterReferences><RelOp NodeId="17" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="190" EstimatedTotalSubtreeCost="12.1109" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1014" /><ColumnReference Column="Expr1015" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1017" /><ColumnReference Column="Expr1018" /><ColumnReference Column="Expr1019" /><ColumnReference Column="Expr1020" /><ColumnReference Column="Expr1021" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1023" /><ColumnReference Column="Expr1024" /><ColumnReference Column="Expr1026" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OuterReferences><RelOp NodeId="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="190" EstimatedTotalSubtreeCost="12.1076" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1013" /><ColumnReference Column="Expr1014" /><ColumnReference Column="Expr1015" /><ColumnReference Column="Expr1016" /><ColumnReference Column="Expr1017" /><ColumnReference Column="Expr1018" /><ColumnReference Column="Expr1019" /><ColumnReference Column="Expr1020" /><ColumnReference Column="Expr1021" /><ColumnReference Column="Expr1022" /><ColumnReference Column="Expr1023" /><ColumnReference Column="Expr1024" /><ColumnReference Column="Expr1026" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1013" /><ScalarOperator ScalarString="ScalarString152"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1416" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1417" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014" /><ScalarOperator ScalarString="ScalarString153"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1418" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1419" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015" /><ScalarOperator ScalarString="ScalarString154"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1420" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1421" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016" /><ScalarOperator ScalarString="ScalarString155"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1422" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1423" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017" /><ScalarOperator ScalarString="ScalarString156"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1424" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1425" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1018" /><ScalarOperator ScalarString="ScalarString157"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1426" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1427" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019" /><ScalarOperator ScalarString="ScalarString158"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1428" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1429" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020" /><ScalarOperator ScalarString="ScalarString159"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1430" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1431" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021" /><ScalarOperator ScalarString="ScalarString160"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1432" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1433" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1022" /><ScalarOperator ScalarString="ScalarString161"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1434" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1435" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023" /><ScalarOperator ScalarString="ScalarString162"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1436" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1437" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024" /><ScalarOperator ScalarString="ScalarString163"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1438" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1439" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1026" /><ScalarOperator ScalarString="ScalarString164"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1440" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1441" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="190" EstimatedTotalSubtreeCost="12.1076" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1416" /><ColumnReference Column="Expr1417" /><ColumnReference Column="Expr1418" /><ColumnReference Column="Expr1419" /><ColumnReference Column="Expr1420" /><ColumnReference Column="Expr1421" /><ColumnReference Column="Expr1422" /><ColumnReference Column="Expr1423" /><ColumnReference Column="Expr1424" /><ColumnReference Column="Expr1425" /><ColumnReference Column="Expr1426" /><ColumnReference Column="Expr1427" /><ColumnReference Column="Expr1428" /><ColumnReference Column="Expr1429" /><ColumnReference Column="Expr1430" /><ColumnReference Column="Expr1431" /><ColumnReference Column="Expr1432" /><ColumnReference Column="Expr1433" /><ColumnReference Column="Expr1434" /><ColumnReference Column="Expr1435" /><ColumnReference Column="Expr1436" /><ColumnReference Column="Expr1437" /><ColumnReference Column="Expr1438" /><ColumnReference Column="Expr1439" /><ColumnReference Column="Expr1440" /><ColumnReference Column="Expr1441" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1416" /><ScalarOperator ScalarString="ScalarString165"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1417" /><ScalarOperator ScalarString="ScalarString166"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1418" /><ScalarOperator ScalarString="ScalarString167"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1419" /><ScalarOperator ScalarString="ScalarString168"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1420" /><ScalarOperator ScalarString="ScalarString169"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1421" /><ScalarOperator ScalarString="ScalarString170"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1422" /><ScalarOperator ScalarString="ScalarString171"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1423" /><ScalarOperator ScalarString="ScalarString172"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1424" /><ScalarOperator ScalarString="ScalarString173"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1425" /><ScalarOperator ScalarString="ScalarString174"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1426" /><ScalarOperator ScalarString="ScalarString175"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1427" /><ScalarOperator ScalarString="ScalarString176"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1428" /><ScalarOperator ScalarString="ScalarString177"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1429" /><ScalarOperator ScalarString="ScalarString178"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1430" /><ScalarOperator ScalarString="ScalarString179"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1431" /><ScalarOperator ScalarString="ScalarString180"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1432" /><ScalarOperator ScalarString="ScalarString181"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1433" /><ScalarOperator ScalarString="ScalarString182"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1434" /><ScalarOperator ScalarString="ScalarString183"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1435" /><ScalarOperator ScalarString="ScalarString184"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1436" /><ScalarOperator ScalarString="ScalarString185"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1437" /><ScalarOperator ScalarString="ScalarString186"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1438" /><ScalarOperator ScalarString="ScalarString187"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1439" /><ScalarOperator ScalarString="ScalarString188"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1440" /><ScalarOperator ScalarString="ScalarString189"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1011" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1441" /><ScalarOperator ScalarString="ScalarString190"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1011" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></GroupBy><RelOp NodeId="20" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.00010019" AvgRowSize="190" EstimatedTotalSubtreeCost="12.1076" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1011" /></OutputList><MemoryFractions Input="0.16" Output="0.1" /><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OrderByColumn></OrderBy><RelOp NodeId="21" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="190" EstimatedTotalSubtreeCost="12.0962" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Column="Expr1011" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></OuterReferences><RelOp NodeId="22" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="89" EstimatedTotalSubtreeCost="12.0929" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Column="Expr1011" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></OuterReferences><RelOp NodeId="23" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.2522" AvgRowSize="94" EstimatedTotalSubtreeCost="12.0897" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Column="Expr1011" /></OutputList><MemoryFractions Input="0.583333" Output="0.84" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString191"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="24" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="44" EstimatedTotalSubtreeCost="6.08253" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Column="Expr1011" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></OuterReferences><RelOp NodeId="25" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="36" EstimatedTotalSubtreeCost="6.07924" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Column="Expr1011" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011" /><ScalarOperator ScalarString="ScalarString192"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1414" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1415" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="26" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="36" EstimatedTotalSubtreeCost="6.07924" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Column="Expr1414" /><ColumnReference Column="Expr1415" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1414" /><ScalarOperator ScalarString="ScalarString193"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1415" /><ScalarOperator ScalarString="ScalarString194"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></GroupBy><RelOp NodeId="27" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100064" AvgRowSize="64" EstimatedTotalSubtreeCost="6.07924" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OutputList><MemoryFractions Input="0.111111" Output="0.416667" /><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></OrderByColumn></OrderBy><RelOp NodeId="28" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="64" EstimatedTotalSubtreeCost="6.06788" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></OuterReferences><RelOp NodeId="29" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="40" EstimatedTotalSubtreeCost="6.0646" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OuterReferences><RelOp NodeId="30" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0309237" AvgRowSize="40" EstimatedTotalSubtreeCost="6.06131" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><MemoryFractions Input="0.375" Output="0.333333" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString195"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="31" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="259" EstimateIO="0.0068287" EstimateCPU="0.0004419" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0072706" TableCardinality="259" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object2" Index="Index1" Alias="Object7" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /></IndexScan></RelOp><RelOp NodeId="32" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1463.51" EstimateIO="0" EstimateCPU="0.253835" AvgRowSize="40" EstimatedTotalSubtreeCost="6.02311" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><MemoryFractions Input="0.625" Output="0.555556" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString196"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="33" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="10" EstimateIO="0.0134954" EstimateCPU="0.0004265" AvgRowSize="115" EstimatedTotalSubtreeCost="0.0139219" TableCardinality="245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object4" Index="Index2" Alias="Object9" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString197"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value6" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value7" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value8" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value9" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value10" /></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="35" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="35855.9" EstimateIO="4.92609" EstimateCPU="0.438396" AvgRowSize="48" EstimatedTotalSubtreeCost="5.36448" TableCardinality="398399" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" TableReferenceId="2" IndexKind="Heap" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString198"><Intrinsic FunctionName="like"><ScalarOperator><Convert DataType="nvarchar" Length="24" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column27" /></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Column28"><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><Identifier><ColumnReference Column="Column29" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value11" /></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></TableScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="39" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList /><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues /><Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index3" Alias="Object10" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object10" Column="Column2" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString199"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="40" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="33" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object3" Index="Index4" Alias="Object8" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString200"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="49" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="259" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object2" Index="Index1" Alias="Object7" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString201"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="51" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="35855.9" EstimateIO="4.92609" EstimateCPU="0.438396" AvgRowSize="81" EstimatedTotalSubtreeCost="5.36448" TableCardinality="398399" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column24" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column13" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column14" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column15" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column16" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column18" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column19" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column20" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" TableReferenceId="1" IndexKind="Heap" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString198"><Intrinsic FunctionName="like"><ScalarOperator><Convert DataType="nvarchar" Length="24" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column27" /></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Column30"><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><Identifier><ColumnReference Column="Column29" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value11" /></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></TableScan></RelOp></Hash></RelOp><RelOp NodeId="54" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList /><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues /><Object Database="Database1" Schema="Schema1" Table="Object4" Index="Index2" Alias="Object9" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString202"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="ScalarString203"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Column31" /></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value10" /></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="55" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="113" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="33" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object3" Index="Index4" Alias="Object8" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString200"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="136" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList /><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues /><Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index3" Alias="Object10" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object10" Column="Column2" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString199"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="137" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="48" EstimatedTotalSubtreeCost="6.1245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /><ColumnReference Column="Expr1046" /><ColumnReference Column="Expr1047" /><ColumnReference Column="Expr1048" /><ColumnReference Column="Expr1049" /><ColumnReference Column="Expr1050" /><ColumnReference Column="Expr1051" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1046" /><ScalarOperator ScalarString="ScalarString204"><Identifier><ColumnReference Column="Expr1037" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1047" /><ScalarOperator ScalarString="ScalarString205"><Identifier><ColumnReference Column="Expr1038" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1048" /><ScalarOperator ScalarString="ScalarString206"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value4" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1039" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1049" /><ScalarOperator ScalarString="ScalarString207"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value5" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1039" /></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1050" /><ScalarOperator ScalarString="ScalarString208"><Identifier><ColumnReference Column="Expr1040" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1051" /><ScalarOperator ScalarString="ScalarString209"><Identifier><ColumnReference Column="Expr1041" /></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="138" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="81" EstimatedTotalSubtreeCost="6.1245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Column="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1039" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1037" /><ScalarOperator ScalarString="ScalarString210"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1442" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1443" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1038" /><ScalarOperator ScalarString="ScalarString211"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1444" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1445" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1039" /><ScalarOperator ScalarString="ScalarString212"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1446" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1447" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1040" /><ScalarOperator ScalarString="ScalarString213"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1448" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1449" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1041" /><ScalarOperator ScalarString="ScalarString214"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1450" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1451" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="139" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-006" AvgRowSize="81" EstimatedTotalSubtreeCost="6.1245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Column="Expr1442" /><ColumnReference Column="Expr1443" /><ColumnReference Column="Expr1444" /><ColumnReference Column="Expr1445" /><ColumnReference Column="Expr1446" /><ColumnReference Column="Expr1447" /><ColumnReference Column="Expr1448" /><ColumnReference Column="Expr1449" /><ColumnReference Column="Expr1450" /><ColumnReference Column="Expr1451" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1442" /><ScalarOperator ScalarString="ScalarString169"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1443" /><ScalarOperator ScalarString="ScalarString170"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1444" /><ScalarOperator ScalarString="ScalarString171"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1445" /><ScalarOperator ScalarString="ScalarString172"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1446" /><ScalarOperator ScalarString="ScalarString181"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1447" /><ScalarOperator ScalarString="ScalarString182"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1448" /><ScalarOperator ScalarString="ScalarString167"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1449" /><ScalarOperator ScalarString="ScalarString168"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1450" /><ScalarOperator ScalarString="ScalarString165"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1451" /><ScalarOperator ScalarString="ScalarString166"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ScalarOperator ScalarString="ScalarString215"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="140" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="81" EstimatedTotalSubtreeCost="6.1245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></OutputList><NestedLoops Optimized="0"><RelOp NodeId="141" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList /><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues /><Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index3" Alias="Object11" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column2" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString199"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="142" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="81" EstimatedTotalSubtreeCost="6.12122" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></OuterReferences><RelOp NodeId="144" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="31" EstimatedTotalSubtreeCost="6.11793" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></OutputList><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OuterReferences><RelOp NodeId="145" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0763511" AvgRowSize="35" EstimatedTotalSubtreeCost="6.11464" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></OutputList><MemoryFractions Input="0.3" Output="0.3" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString195"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="146" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.00388" EstimateIO="0.0068287" EstimateCPU="0.0004419" AvgRowSize="115" EstimatedTotalSubtreeCost="0.0072706" TableCardinality="259" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column23" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object2" Index="Index1" Alias="Object7" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString216"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="147" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="8963.98" EstimateIO="0" EstimateCPU="0.261931" AvgRowSize="39" EstimatedTotalSubtreeCost="6.03089" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></OutputList><MemoryFractions Input="0.5" Output="0.5" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString196"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="148" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimateIO="0.0134954" EstimateCPU="0.0004265" AvgRowSize="115" EstimatedTotalSubtreeCost="0.0139219" TableCardinality="245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column22" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object4" Index="Index2" Alias="Object9" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString217"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value10" /></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="150" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="35855.9" EstimateIO="4.92609" EstimateCPU="0.438396" AvgRowSize="48" EstimatedTotalSubtreeCost="5.36448" TableCardinality="398399" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></OutputList><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column10" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column11" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column12" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column17" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" TableReferenceId="3" IndexKind="Heap" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString218"><Intrinsic FunctionName="like"><ScalarOperator><Convert DataType="varchar" Length="12" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column27" /></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="Value12" /></ScalarOperator></Intrinsic></ScalarOperator></Predicate></TableScan></RelOp></Hash></RelOp></Hash></RelOp><RelOp NodeId="154" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5845" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList /><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues /><Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index3" Alias="Object12" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object12" Column="Column2" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString199"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="ScalarString219"><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Intrinsic FunctionName="datepart"><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="Value13" /></ScalarOperator><ScalarOperator><Const ConstValue="Value14" /></ScalarOperator><ScalarOperator><Intrinsic FunctionName="eomonth"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object12" Column="Column32" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="" /></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="Value15" /></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Intrinsic FunctionName="datepart"><ScalarOperator><Const ConstValue="Value16" /></ScalarOperator><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="Value13" /></ScalarOperator><ScalarOperator><Const ConstValue="Value14" /></ScalarOperator><ScalarOperator><Intrinsic FunctionName="eomonth"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object12" Column="Column32" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="" /></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="Value17" /></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="datepart"><ScalarOperator><Const ConstValue="Value13" /></ScalarOperator><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="Value13" /></ScalarOperator><ScalarOperator><Const ConstValue="Value14" /></ScalarOperator><ScalarOperator><Intrinsic FunctionName="eomonth"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object12" Column="Column32" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="" /></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="156" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="113" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="33" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object3" Index="Index4" Alias="Object8" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString200"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="ScalarString220"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp></NestedLoops></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Segment></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement