Advertisement
Guest User

Untitled

a guest
Apr 19th, 2016
311
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 236.96 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="72.7913" StatementEstRows="43.3716" StatementOptmLevel="FULL" QueryHash="0x1228C42DD6741160" QueryPlanHash="0xBE788E89772E185" 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="1000" CompileTime="1376" CompileCPU="1367" CompileMemory="18888"><ThreadStat Branches="5" /><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="9728" SerialDesiredMemory="15616" /><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="358400" EstimatedPagesCached="179200" EstimatedAvailableDegreeOfParallelism="4" /><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="43.3716" EstimateIO="0" EstimateCPU="4.33716e-006" AvgRowSize="248" EstimatedTotalSubtreeCost="72.7913" 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="43.3716" EstimateIO="0" EstimateCPU="4.77088e-005" AvgRowSize="146" EstimatedTotalSubtreeCost="72.7913" 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="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="Expr1104" /><ScalarOperator ScalarString="ScalarString3"><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="Expr1105" /><ScalarOperator ScalarString="ScalarString4"><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="Expr1106" /><ScalarOperator ScalarString="ScalarString5"><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="Expr1107" /><ScalarOperator ScalarString="ScalarString6"><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="Expr1108" /><ScalarOperator ScalarString="ScalarString7"><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="Expr1109" /><ScalarOperator ScalarString="ScalarString8"><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="Expr1110" /><ScalarOperator ScalarString="ScalarString9"><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><DefinedValue><ColumnReference Column="Expr1111" /><ScalarOperator ScalarString="ScalarString10"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1503" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1504" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1112" /><ScalarOperator ScalarString="ScalarString11"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1505" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1506" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1113" /><ScalarOperator ScalarString="ScalarString12"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1507" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1508" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1114" /><ScalarOperator ScalarString="ScalarString13"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1509" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1510" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="43.3716" EstimateIO="0" EstimateCPU="4.77088e-005" AvgRowSize="146" EstimatedTotalSubtreeCost="72.7913" 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="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" /><ColumnReference Column="Expr1503" /><ColumnReference Column="Expr1504" /><ColumnReference Column="Expr1505" /><ColumnReference Column="Expr1506" /><ColumnReference Column="Expr1507" /><ColumnReference Column="Expr1508" /><ColumnReference Column="Expr1509" /><ColumnReference Column="Expr1510" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1487" /><ScalarOperator ScalarString="ScalarString14"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1052" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1488" /><ScalarOperator ScalarString="ScalarString15"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1052" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1489" /><ScalarOperator ScalarString="ScalarString16"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1053" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1490" /><ScalarOperator ScalarString="ScalarString17"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1053" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1491" /><ScalarOperator ScalarString="ScalarString18"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1054" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1492" /><ScalarOperator ScalarString="ScalarString19"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1054" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1493" /><ScalarOperator ScalarString="ScalarString20"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1055" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1494" /><ScalarOperator ScalarString="ScalarString21"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1055" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1495" /><ScalarOperator ScalarString="ScalarString22"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1056" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1496" /><ScalarOperator ScalarString="ScalarString23"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1056" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1497" /><ScalarOperator ScalarString="ScalarString24"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1057" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1498" /><ScalarOperator ScalarString="ScalarString25"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1057" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1499" /><ScalarOperator ScalarString="ScalarString26"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1058" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1500" /><ScalarOperator ScalarString="ScalarString27"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1058" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1501" /><ScalarOperator ScalarString="ScalarString28"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1059" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1502" /><ScalarOperator ScalarString="ScalarString29"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1059" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1503" /><ScalarOperator ScalarString="ScalarString30"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1060" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1504" /><ScalarOperator ScalarString="ScalarString31"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1060" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1505" /><ScalarOperator ScalarString="ScalarString32"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1061" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1506" /><ScalarOperator ScalarString="ScalarString33"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1061" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1507" /><ScalarOperator ScalarString="ScalarString34"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1062" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1508" /><ScalarOperator ScalarString="ScalarString35"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1062" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1509" /><ScalarOperator ScalarString="ScalarString36"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1063" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1510" /><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="43.3716" EstimateIO="0.0112613" EstimateCPU="0.000468126" AvgRowSize="146" EstimatedTotalSubtreeCost="72.7912" 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.4" 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="43.3716" EstimateIO="0" EstimateCPU="4.33716e-006" AvgRowSize="146" EstimatedTotalSubtreeCost="72.7795" 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="43.3716" EstimateIO="0" EstimateCPU="4.33716e-006" AvgRowSize="216" EstimatedTotalSubtreeCost="72.7795" 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="43.3716" EstimateIO="0" EstimateCPU="0" AvgRowSize="191" EstimatedTotalSubtreeCost="72.7795" 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="43.3716" EstimateIO="0" EstimateCPU="2.72374e-005" AvgRowSize="191" EstimatedTotalSubtreeCost="72.7795" 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="86.7433" EstimateIO="0" EstimateCPU="9.53309e-005" AvgRowSize="191" EstimatedTotalSubtreeCost="72.7794" 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="43.3716" EstimateIO="0" EstimateCPU="0" AvgRowSize="191" EstimatedTotalSubtreeCost="72.7793" 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="43.3716" EstimateIO="0" EstimateCPU="2.72374e-006" AvgRowSize="183" EstimatedTotalSubtreeCost="72.7793" 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="43.3716" EstimateIO="0" EstimateCPU="4.77088e-005" AvgRowSize="175" EstimatedTotalSubtreeCost="72.7793" 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="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="Expr1053" /><ScalarOperator ScalarString="ScalarString117"><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="Expr1054" /><ScalarOperator ScalarString="ScalarString118"><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="Expr1055" /><ScalarOperator ScalarString="ScalarString119"><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="Expr1056" /><ScalarOperator ScalarString="ScalarString120"><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="Expr1057" /><ScalarOperator ScalarString="ScalarString121"><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="Expr1058" /><ScalarOperator ScalarString="ScalarString122"><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="Expr1059" /><ScalarOperator ScalarString="ScalarString123"><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><DefinedValue><ColumnReference Column="Expr1060" /><ScalarOperator ScalarString="ScalarString124"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1476" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1477" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1061" /><ScalarOperator ScalarString="ScalarString125"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1478" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1479" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1062" /><ScalarOperator ScalarString="ScalarString126"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1480" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1481" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1063" /><ScalarOperator ScalarString="ScalarString127"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1482" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1483" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="43.3716" EstimateIO="0" EstimateCPU="4.77088e-005" AvgRowSize="175" EstimatedTotalSubtreeCost="72.7793" 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="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" /><ColumnReference Column="Expr1476" /><ColumnReference Column="Expr1477" /><ColumnReference Column="Expr1478" /><ColumnReference Column="Expr1479" /><ColumnReference Column="Expr1480" /><ColumnReference Column="Expr1481" /><ColumnReference Column="Expr1482" /><ColumnReference Column="Expr1483" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1460" /><ScalarOperator ScalarString="ScalarString89"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1013" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1461" /><ScalarOperator ScalarString="ScalarString90"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1013" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1462" /><ScalarOperator ScalarString="ScalarString128"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1014" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1463" /><ScalarOperator ScalarString="ScalarString129"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1014" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1464" /><ScalarOperator ScalarString="ScalarString130"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1015" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1465" /><ScalarOperator ScalarString="ScalarString131"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1015" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1466" /><ScalarOperator ScalarString="ScalarString132"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1467" /><ScalarOperator ScalarString="ScalarString133"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1016" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1468" /><ScalarOperator ScalarString="ScalarString134"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1017" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1469" /><ScalarOperator ScalarString="ScalarString135"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="Expr1017" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1470" /><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="Expr1471" /><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="Expr1472" /><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="Expr1473" /><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="Expr1474" /><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="Expr1475" /><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="Expr1476" /><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="Expr1477" /><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="Expr1478" /><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="Expr1479" /><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="Expr1480" /><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="Expr1481" /><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="Expr1482" /><ScalarOperator ScalarString="ScalarString148"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1026" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1483" /><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="43.3716" EstimateIO="0.0112613" EstimateCPU="0.000468219" AvgRowSize="239" EstimatedTotalSubtreeCost="72.7793" 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.0108893" Output="0.6" /><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="43.3716" EstimateIO="0" EstimateCPU="4.33716e-006" AvgRowSize="239" EstimatedTotalSubtreeCost="72.7676" 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="Parallelism" LogicalOp="Gather Streams" EstimateRows="43.3716" EstimateIO="0" EstimateCPU="0.0288211" AvgRowSize="231" EstimatedTotalSubtreeCost="72.7676" Parallel="1" 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><Parallelism><RelOp NodeId="17" PhysicalOp="Merge Join" LogicalOp="Left Outer Join" EstimateRows="43.3716" EstimateIO="0" EstimateCPU="0.00259675" AvgRowSize="231" EstimatedTotalSubtreeCost="72.7387" Parallel="1" 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><Merge ManyToMany="0"><InnerSideJoinColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /><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="Object2" Alias="Object7" Column="Column3" /></InnerSideJoinColumns><OuterSideJoinColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><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="Object2" Alias="Object7" Column="Column3" /></OuterSideJoinColumns><Residual><ScalarOperator ScalarString="ScalarString152"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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="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><ScalarOperator><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></Logical></ScalarOperator></Residual><RelOp NodeId="18" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="43.305" EstimateIO="0" EstimateCPU="0.0290709" AvgRowSize="190" EstimatedTotalSubtreeCost="47.7056" Parallel="1" 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><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><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="Object2" Alias="Object7" Column="Column3" /></PartitionColumns><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="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="Object2" Alias="Object7" Column="Column3" /></OrderByColumn></OrderBy><RelOp NodeId="19" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="43.305" EstimateIO="0" EstimateCPU="4.52538e-005" AvgRowSize="190" EstimatedTotalSubtreeCost="47.6765" Parallel="1" 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" WithOrderedPrefetch="1"><OuterReferences><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Column="Expr1449" /></OuterReferences><RelOp NodeId="21" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="43.305" EstimateIO="0" EstimateCPU="1.50849e-005" AvgRowSize="190" EstimatedTotalSubtreeCost="47.6632" Parallel="1" 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="ScalarString153"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1423" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1424" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1014" /><ScalarOperator ScalarString="ScalarString154"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1425" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1426" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015" /><ScalarOperator ScalarString="ScalarString155"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1427" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1428" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016" /><ScalarOperator ScalarString="ScalarString156"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1429" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1430" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017" /><ScalarOperator ScalarString="ScalarString157"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1431" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1432" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1018" /><ScalarOperator ScalarString="ScalarString158"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1433" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1434" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1019" /><ScalarOperator ScalarString="ScalarString159"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1435" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1436" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020" /><ScalarOperator ScalarString="ScalarString160"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1437" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1438" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021" /><ScalarOperator ScalarString="ScalarString161"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1439" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1440" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1022" /><ScalarOperator ScalarString="ScalarString162"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1441" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1442" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1023" /><ScalarOperator ScalarString="ScalarString163"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1443" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1444" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024" /><ScalarOperator ScalarString="ScalarString164"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1445" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1446" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1026" /><ScalarOperator ScalarString="ScalarString165"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1447" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value2" /></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="Value3" /></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1448" /></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="22" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="43.305" EstimateIO="0" EstimateCPU="1.50849e-005" AvgRowSize="190" EstimatedTotalSubtreeCost="47.6632" Parallel="1" 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="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" /><ColumnReference Column="Expr1442" /><ColumnReference Column="Expr1443" /><ColumnReference Column="Expr1444" /><ColumnReference Column="Expr1445" /><ColumnReference Column="Expr1446" /><ColumnReference Column="Expr1447" /><ColumnReference Column="Expr1448" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1423" /><ScalarOperator ScalarString="ScalarString166"><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="Expr1424" /><ScalarOperator ScalarString="ScalarString167"><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="Expr1425" /><ScalarOperator ScalarString="ScalarString168"><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="Expr1426" /><ScalarOperator ScalarString="ScalarString169"><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="Expr1427" /><ScalarOperator ScalarString="ScalarString170"><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="Expr1428" /><ScalarOperator ScalarString="ScalarString171"><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="Expr1429" /><ScalarOperator ScalarString="ScalarString172"><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="Expr1430" /><ScalarOperator ScalarString="ScalarString173"><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="Expr1431" /><ScalarOperator ScalarString="ScalarString174"><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="Expr1432" /><ScalarOperator ScalarString="ScalarString175"><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="Expr1433" /><ScalarOperator ScalarString="ScalarString176"><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="Expr1434" /><ScalarOperator ScalarString="ScalarString177"><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="Expr1435" /><ScalarOperator ScalarString="ScalarString178"><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="Expr1436" /><ScalarOperator ScalarString="ScalarString179"><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="Expr1437" /><ScalarOperator ScalarString="ScalarString180"><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="Expr1438" /><ScalarOperator ScalarString="ScalarString181"><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="Expr1439" /><ScalarOperator ScalarString="ScalarString182"><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="Expr1440" /><ScalarOperator ScalarString="ScalarString183"><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="Expr1441" /><ScalarOperator ScalarString="ScalarString184"><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="Expr1442" /><ScalarOperator ScalarString="ScalarString185"><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="Expr1443" /><ScalarOperator ScalarString="ScalarString186"><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="Expr1444" /><ScalarOperator ScalarString="ScalarString187"><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="Expr1445" /><ScalarOperator ScalarString="ScalarString188"><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="Expr1446" /><ScalarOperator ScalarString="ScalarString189"><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="Expr1447" /><ScalarOperator ScalarString="ScalarString190"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1011" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1448" /><ScalarOperator ScalarString="ScalarString191"><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="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></GroupBy><RelOp NodeId="23" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="64.4782" EstimateIO="0.00281532" EstimateCPU="0.000176197" AvgRowSize="190" EstimatedTotalSubtreeCost="47.6631" Parallel="1" 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.00907332" Output="0.0108893" /><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="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="Object2" Alias="Object7" Column="Column3" /></OrderByColumn></OrderBy><RelOp NodeId="24" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="64.4782" EstimateIO="0" EstimateCPU="0.0290276" AvgRowSize="190" EstimatedTotalSubtreeCost="47.6602" Parallel="1" 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><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><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="Object2" Alias="Object7" Column="Column3" /></PartitionColumns><RelOp NodeId="25" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="64.4782" EstimateIO="0" EstimateCPU="6.73797e-005" AvgRowSize="190" EstimatedTotalSubtreeCost="47.6311" Parallel="1" 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="26" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="64.4782" EstimateIO="0" EstimateCPU="6.73797e-005" AvgRowSize="89" EstimatedTotalSubtreeCost="47.6177" Parallel="1" 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="27" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="64.4782" EstimateIO="0" EstimateCPU="0.106995" AvgRowSize="90" EstimatedTotalSubtreeCost="47.5988" Parallel="1" 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="Object1" Alias="Object6" Column="Column22" /><ColumnReference Column="Expr1011" /></OutputList><MemoryFractions Input="0.164402" Output="0.182979" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString192"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></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="Column23" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="28" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.0328489" AvgRowSize="36" EstimatedTotalSubtreeCost="23.9011" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Column="Expr1011" /></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Column24" /></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></HashKeys><RelOp NodeId="29" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.0328489" AvgRowSize="36" EstimatedTotalSubtreeCost="23.9011" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Column="Expr1011" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></PartitionColumns><RelOp NodeId="30" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.00078794" AvgRowSize="36" EstimatedTotalSubtreeCost="23.8682" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Column="Expr1011" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011" /><ScalarOperator ScalarString="ScalarString193"><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></DefinedValues><RelOp NodeId="31" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.00078794" AvgRowSize="36" EstimatedTotalSubtreeCost="23.8682" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><ColumnReference Column="Expr1420" /><ColumnReference Column="Expr1421" /></OutputList><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1420" /><ScalarOperator ScalarString="ScalarString194"><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="Expr1421" /><ScalarOperator ScalarString="ScalarString195"><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="Column22" /><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="Column23" /></GroupBy><RelOp NodeId="32" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2865.24" EstimateIO="0.00281532" EstimateCPU="0.0128582" AvgRowSize="64" EstimatedTotalSubtreeCost="23.8675" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="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.12635" Output="0.103261" /><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="Column22" /></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="Column23" /></OrderByColumn></OrderBy><RelOp NodeId="33" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.0386521" AvgRowSize="64" EstimatedTotalSubtreeCost="23.8518" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="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><Parallelism PartitioningType="Hash"><PartitionColumns><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="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="Column23" /></PartitionColumns><RelOp NodeId="34" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.026258" AvgRowSize="64" EstimatedTotalSubtreeCost="23.8131" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="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.0130214" Output="0.0149625" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString196"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="35" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="33" EstimateIO="0" EstimateCPU="0.0286575" AvgRowSize="39" EstimatedTotalSubtreeCost="0.0319758" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OutputList><Parallelism PartitioningType="Broadcast"><RelOp NodeId="36" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="33" EstimateIO="0.003125" EstimateCPU="0.0001933" AvgRowSize="39" EstimatedTotalSubtreeCost="0.0033183" TableCardinality="33" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /><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="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></DefinedValue><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="Index1" Alias="Object8" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /></IndexScan></RelOp></Parallelism></RelOp><RelOp NodeId="37" PhysicalOp="Merge Join" LogicalOp="Inner Join" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.00604451" AvgRowSize="40" EstimatedTotalSubtreeCost="23.7549" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><Merge ManyToMany="0"><InnerSideJoinColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></InnerSideJoinColumns><OuterSideJoinColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></OuterSideJoinColumns><Residual><ScalarOperator ScalarString="ScalarString197"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></Compare></ScalarOperator></Residual><RelOp NodeId="38" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="5845" EstimateIO="0" EstimateCPU="0.0612265" AvgRowSize="11" EstimatedTotalSubtreeCost="0.262294" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></PartitionColumns><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></OrderByColumn></OrderBy><RelOp NodeId="39" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="5845" EstimateIO="0.199421" EstimateCPU="0.00164663" AvgRowSize="11" EstimatedTotalSubtreeCost="0.201068" TableCardinality="5845" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></OutputList><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object4" Index="Index2" Alias="Object10" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString198"><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Column26" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value6" /></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp><RelOp NodeId="40" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2865.24" EstimateIO="0.00281532" EstimateCPU="0.0128582" AvgRowSize="40" EstimatedTotalSubtreeCost="23.4865" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><MemoryFractions Input="0.083916" Output="0.0964252" /><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></OrderByColumn></OrderBy><RelOp NodeId="41" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.0330337" AvgRowSize="40" EstimatedTotalSubtreeCost="23.4709" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Column26" /></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></HashKeys><RelOp NodeId="42" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.0330337" AvgRowSize="40" EstimatedTotalSubtreeCost="23.4709" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></PartitionColumns><RelOp NodeId="43" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2865.24" EstimateIO="0" EstimateCPU="0.0322949" AvgRowSize="40" EstimatedTotalSubtreeCost="23.4378" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><MemoryFractions Input="0.114299" Output="0.0723414" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString199"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="44" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="259" EstimateIO="0" EstimateCPU="0.0286552" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0355943" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Column27" /></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></HashKeys><RelOp NodeId="45" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="259" EstimateIO="0" EstimateCPU="0.0286552" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0355943" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></PartitionColumns><RelOp NodeId="46" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="259" EstimateIO="0.0068287" EstimateCPU="0.000110475" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00693918" TableCardinality="259" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object2" Index="Index3" Alias="Object7" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /></IndexScan></RelOp></Parallelism></RelOp></Bitmap></RelOp><RelOp NodeId="47" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="6430.91" EstimateIO="0" EstimateCPU="0.0386757" AvgRowSize="40" EstimatedTotalSubtreeCost="23.3699" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></PartitionColumns><Predicate><ScalarOperator ScalarString="ScalarString200"><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Column27" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate><RelOp NodeId="48" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="6430.91" EstimateIO="0" EstimateCPU="0.0353297" AvgRowSize="40" EstimatedTotalSubtreeCost="23.3313" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="Object1" Alias="Object6" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column25" /></OutputList><MemoryFractions Input="0.114299" Output="0.0723414" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString201"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="49" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="10" EstimateIO="0" EstimateCPU="0.0285187" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0428767" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Column29" /></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></HashKeys><RelOp NodeId="50" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="10" EstimateIO="0" EstimateCPU="0.0285187" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0428767" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></OutputList><Parallelism PartitioningType="Broadcast"><RelOp NodeId="51" 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="Object5" Alias="Object11" Column="Column28" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index4" Alias="Object11" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString202"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value7" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value8" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value9" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value10" /></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value11" /></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp></Bitmap></RelOp><RelOp NodeId="53" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="6430.91" EstimateIO="22.1676" EstimateCPU="0.481445" AvgRowSize="48" EstimatedTotalSubtreeCost="22.6491" TableCardinality="1.75064e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><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="Column22" /></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="Column28" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></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="ScalarString203"><Logical Operation="AND"><ScalarOperator><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="Column31" /></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Column32"><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><Identifier><ColumnReference Column="Column33" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value12" /></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Column29" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value6" /></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></TableScan></RelOp></Hash></RelOp></Parallelism></RelOp></Hash></RelOp></Parallelism></RelOp></Bitmap></RelOp></Sort></RelOp></Merge></RelOp></Hash></RelOp></Parallelism></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Parallelism></RelOp></Bitmap></RelOp><RelOp NodeId="67" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="39389.3" EstimateIO="0" EstimateCPU="0.169821" AvgRowSize="72" EstimatedTotalSubtreeCost="23.5907" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="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><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></PartitionColumns><Predicate><ScalarOperator ScalarString="ScalarString204"><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Column24" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator><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="Column23" /></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate><RelOp NodeId="68" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="39389.3" EstimateIO="0" EstimateCPU="0.125219" AvgRowSize="72" EstimatedTotalSubtreeCost="23.4209" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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="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><MemoryFractions Input="0.103261" Output="0.075611" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString201"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="69" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0285037" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0426412" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Column34" /></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></HashKeys><RelOp NodeId="70" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0285037" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0426412" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></OutputList><Parallelism PartitioningType="Broadcast"><RelOp NodeId="71" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimateIO="0.0134954" EstimateCPU="0.0004265" AvgRowSize="42" EstimatedTotalSubtreeCost="0.0139219" TableCardinality="245" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index4" Alias="Object11" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString205"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Column35" /></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value11" /></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp></Bitmap></RelOp><RelOp NodeId="73" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="39389.3" EstimateIO="22.1676" EstimateCPU="0.481445" AvgRowSize="81" EstimatedTotalSubtreeCost="22.6491" TableCardinality="1.75064e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /><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="Column22" /></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="Column28" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column23" /></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="ScalarString206"><Logical Operation="AND"><ScalarOperator><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="Column31" /></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Column36"><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><Identifier><ColumnReference Column="Column33" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value12" /></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Column34" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value6" /></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></TableScan></RelOp></Hash></RelOp></Parallelism></RelOp></Hash></RelOp><RelOp NodeId="77" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0188322" TableCardinality="259" Parallel="1" EstimateRebinds="24.8001" EstimateRewinds="38.6781" 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="Index3" 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="Column22" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString207"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="78" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="113" EstimatedTotalSubtreeCost="0.013319" TableCardinality="33" Parallel="1" EstimateRebinds="24.4182" EstimateRewinds="39.0601" 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="Index1" 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="ScalarString208"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Parallelism></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="159" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.013323" TableCardinality="5845" Parallel="1" EstimateRebinds="2.09607" EstimateRewinds="40.209" 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="Object10" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object10" Column="Column2" /></RangeColumns><RangeExpressions><ScalarOperator ScalarString="ScalarString209"><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Parallelism></RelOp><RelOp NodeId="160" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2234.15" EstimateIO="0" EstimateCPU="5.58538e-005" AvgRowSize="260" EstimatedTotalSubtreeCost="25.0305" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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="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="ScalarString210"><Identifier><ColumnReference Column="Expr1037" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1047" /><ScalarOperator ScalarString="ScalarString211"><Identifier><ColumnReference Column="Expr1038" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1048" /><ScalarOperator ScalarString="ScalarString212"><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="ScalarString213"><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="ScalarString214"><Identifier><ColumnReference Column="Expr1040" /></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1051" /><ScalarOperator ScalarString="ScalarString215"><Identifier><ColumnReference Column="Expr1041" /></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="161" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2234.15" EstimateIO="0.00281532" EstimateCPU="0.00971893" AvgRowSize="240" EstimatedTotalSubtreeCost="25.0305" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1039" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /></OutputList><MemoryFractions Input="0.563393" Output="0.206961" /><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></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="Object2" Alias="Object7" Column="Column3" /></OrderByColumn></OrderBy><RelOp NodeId="162" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="2234.15" EstimateIO="0" EstimateCPU="0.0465501" AvgRowSize="240" EstimatedTotalSubtreeCost="25.0179" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1039" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /><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="Object2" Alias="Object7" Column="Column3" /></PartitionColumns><RelOp NodeId="163" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2234.15" EstimateIO="0" EstimateCPU="0.147014" AvgRowSize="240" EstimatedTotalSubtreeCost="24.9714" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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="Expr1037" /><ColumnReference Column="Expr1038" /><ColumnReference Column="Expr1039" /><ColumnReference Column="Expr1040" /><ColumnReference Column="Expr1041" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1037" /><ScalarOperator ScalarString="ScalarString216"><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><DefinedValue><ColumnReference Column="Expr1038" /><ScalarOperator ScalarString="ScalarString217"><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="Expr1039" /><ScalarOperator ScalarString="ScalarString218"><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="Expr1040" /><ScalarOperator ScalarString="ScalarString219"><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="Expr1041" /><ScalarOperator ScalarString="ScalarString220"><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></DefinedValues><RelOp NodeId="164" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="2234.15" EstimateIO="0" EstimateCPU="0.147014" AvgRowSize="240" EstimatedTotalSubtreeCost="24.9714" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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="Expr1450" /><ColumnReference Column="Expr1451" /><ColumnReference Column="Expr1452" /><ColumnReference Column="Expr1453" /><ColumnReference Column="Expr1454" /><ColumnReference Column="Expr1455" /><ColumnReference Column="Expr1456" /><ColumnReference Column="Expr1457" /><ColumnReference Column="Expr1458" /><ColumnReference Column="Expr1459" /></OutputList><MemoryFractions Input="0.0591316" Output="0.160969" /><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1450" /><ScalarOperator ScalarString="ScalarString170"><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="Expr1451" /><ScalarOperator ScalarString="ScalarString171"><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="Expr1452" /><ScalarOperator ScalarString="ScalarString172"><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="Expr1453" /><ScalarOperator ScalarString="ScalarString173"><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="Expr1454" /><ScalarOperator ScalarString="ScalarString182"><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="Expr1455" /><ScalarOperator ScalarString="ScalarString183"><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="Expr1456" /><ScalarOperator ScalarString="ScalarString168"><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="Expr1457" /><ScalarOperator ScalarString="ScalarString169"><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="Expr1458" /><ScalarOperator ScalarString="ScalarString166"><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="Expr1459" /><ScalarOperator ScalarString="ScalarString167"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column9" /></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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" /></HashKeysBuild><BuildResidual><ScalarOperator ScalarString="ScalarString221"><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><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></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><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></Logical></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><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></BuildResidual><RelOp NodeId="165" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.170286" AvgRowSize="240" EstimatedTotalSubtreeCost="24.8244" Parallel="1" 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="Object4" Alias="Object9" 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" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" 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" /></PartitionColumns><RelOp NodeId="166" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.0859822" AvgRowSize="240" EstimatedTotalSubtreeCost="24.6541" Parallel="1" 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="Object4" Alias="Object9" 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" /></OutputList><MemoryFractions Input="0.269258" Output="0.247278" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1126" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString222"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1126" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="167" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="5845" EstimateIO="0" EstimateCPU="0.0320015" AvgRowSize="11" EstimatedTotalSubtreeCost="0.233069" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></PartitionColumns><RelOp NodeId="168" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="5845" EstimateIO="0.199421" EstimateCPU="0.00164663" AvgRowSize="11" EstimatedTotalSubtreeCost="0.201068" TableCardinality="5845" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object9" Column="Column2" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object4" Index="Index2" Alias="Object9" IndexKind="Clustered" Storage="RowStore" /></IndexScan></RelOp></Parallelism></RelOp><RelOp NodeId="169" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.125291" AvgRowSize="240" EstimatedTotalSubtreeCost="24.335" Parallel="1" 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="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="Expr1126" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Column="Expr1126" /></PartitionColumns><RelOp NodeId="170" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.0899067" AvgRowSize="240" EstimatedTotalSubtreeCost="24.2097" Parallel="1" 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="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="Expr1126" /></OutputList><MemoryFractions Input="0.280965" Output="0.258029" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column2" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString223"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column2" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="171" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="5845" EstimateIO="0" EstimateCPU="0.000146125" AvgRowSize="15" EstimatedTotalSubtreeCost="0.234224" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column2" /><ColumnReference Column="Expr1126" /></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1126" /><ScalarOperator ScalarString="ScalarString224"><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="Object4" Alias="Object12" Column="Column37" /></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="Object4" Alias="Object12" Column="Column37" /></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="Object4" Alias="Object12" Column="Column37" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="" /></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="172" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="5845" EstimateIO="0" EstimateCPU="0.0330098" AvgRowSize="14" EstimatedTotalSubtreeCost="0.234078" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column37" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column2" /></PartitionColumns><RelOp NodeId="173" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="5845" EstimateIO="0.199421" EstimateCPU="0.00164663" AvgRowSize="14" EstimatedTotalSubtreeCost="0.201068" TableCardinality="5845" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column37" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column2" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object4" Alias="Object12" Column="Column37" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object4" Index="Index2" Alias="Object12" IndexKind="Clustered" Storage="RowStore" /></IndexScan></RelOp></Parallelism></RelOp></ComputeScalar></RelOp><RelOp NodeId="177" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.125291" AvgRowSize="240" EstimatedTotalSubtreeCost="23.8856" Parallel="1" 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="Column17" /><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" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /></PartitionColumns><RelOp NodeId="178" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.06632" AvgRowSize="240" EstimatedTotalSubtreeCost="23.7603" Parallel="1" 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="Column17" /><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" /></OutputList><MemoryFractions Input="0.0278038" Output="0.0255341" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString196"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column21" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="179" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="33" EstimateIO="0" EstimateCPU="0.0288351" AvgRowSize="117" EstimatedTotalSubtreeCost="0.0321534" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column8" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column4" /></OutputList><Parallelism PartitioningType="Broadcast"><RelOp NodeId="180" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="33" EstimateIO="0.003125" EstimateCPU="0.0001933" AvgRowSize="117" EstimatedTotalSubtreeCost="0.0033183" TableCardinality="33" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /><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="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object3" Alias="Object8" Column="Column21" /></DefinedValue><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="Index1" Alias="Object8" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore" /></IndexScan></RelOp></Parallelism></RelOp><RelOp NodeId="181" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.0708784" AvgRowSize="139" EstimatedTotalSubtreeCost="23.6618" Parallel="1" 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" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OutputList><MemoryFractions Input="0.0731679" Output="0.067195" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString199"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="182" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="259" EstimateIO="0" EstimateCPU="0.0291511" AvgRowSize="115" EstimatedTotalSubtreeCost="0.0360903" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Column38" /></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></HashKeys><RelOp NodeId="183" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="259" EstimateIO="0" EstimateCPU="0.0291511" AvgRowSize="115" EstimatedTotalSubtreeCost="0.0360903" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OutputList><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></PartitionColumns><RelOp NodeId="184" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="259" EstimateIO="0.0068287" EstimateCPU="0.000110475" AvgRowSize="115" EstimatedTotalSubtreeCost="0.00693918" TableCardinality="259" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column22" /></DefinedValue><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object2" Alias="Object7" Column="Column3" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object2" Index="Index3" Alias="Object7" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore" /></IndexScan></RelOp></Parallelism></RelOp></Bitmap></RelOp><RelOp NodeId="185" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.0623235" AvgRowSize="39" EstimatedTotalSubtreeCost="23.5549" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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><Parallelism PartitioningType="Hash"><PartitionColumns><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></PartitionColumns><RelOp NodeId="186" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="17549.6" EstimateIO="0" EstimateCPU="0.065636" AvgRowSize="39" EstimatedTotalSubtreeCost="23.4925" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><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.0731679" Output="0.067195" /><Hash><DefinedValues /><HashKeysBuild><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></HashKeysBuild><HashKeysProbe><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="ScalarString201"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="187" PhysicalOp="Bitmap" LogicalOp="Bitmap Create" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0285037" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0425432" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></OutputList><Bitmap><DefinedValues><DefinedValue><ColumnReference Column="Column39" /></DefinedValue></DefinedValues><HashKeys><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></HashKeys><RelOp NodeId="188" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="2" EstimateIO="0" EstimateCPU="0.0285037" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0425432" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></OutputList><Parallelism PartitioningType="Broadcast"><RelOp NodeId="189" 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="Object5" Alias="Object11" Column="Column28" /></OutputList><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column28" /></DefinedValue></DefinedValues><Object Database="Database1" Schema="Schema1" Table="Object5" Index="Index4" Alias="Object11" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore" /><Predicate><ScalarOperator ScalarString="ScalarString225"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object5" Alias="Object11" Column="Column30" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value11" /></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp></Bitmap></RelOp><RelOp NodeId="191" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="17549.6" EstimateIO="22.1676" EstimateCPU="0.481445" AvgRowSize="48" EstimatedTotalSubtreeCost="22.6491" TableCardinality="1.75064e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column2" /><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /><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="Column22" /></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="Column28" /></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="ScalarString226"><Logical Operation="AND"><ScalarOperator><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="Column31" /></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="Value18" /></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Column39" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column28" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value6" /></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="PROBE"><ScalarOperator><Identifier><ColumnReference Column="Column38" /></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="Database1" Schema="Schema1" Table="Object1" Alias="Object6" Column="Column22" /></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="Value6" /></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></TableScan></RelOp></Hash></RelOp></Parallelism></RelOp></Hash></RelOp></Hash></RelOp></Parallelism></RelOp></Hash></RelOp></Parallelism></RelOp></Hash></RelOp></Parallelism></RelOp></Hash></RelOp></ComputeScalar></RelOp></Parallelism></RelOp></Sort></RelOp></ComputeScalar></RelOp></Merge></RelOp></Parallelism></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