Skip to content

Instantly share code, notes, and snippets.

@codingbadger

codingbadger/gist:9481785

Created March 11, 2014 08:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save codingbadger/9481785 to your computer and use it in GitHub Desktop.
Save codingbadger/9481785 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.xml
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="11.0.3128.0">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="Statement1" StatementId="1" StatementCompId="4" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="7638.38" StatementEstRows="159878" StatementOptmLevel="FULL" QueryHash="0xAA0D58BE367C7AA2" QueryPlanHash="0x493DCD293A599B9A">
<StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
<QueryPlan DegreeOfParallelism="4" MemoryGrant="12640256" CachedPlanSize="432" CompileTime="828" CompileCPU="828" CompileMemory="9160">
<ThreadStat Branches="3" UsedThreads="12">
<ThreadReservation NodeId="0" ReservedThreads="12" />
</ThreadStat>
<Warnings>
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="TRY_CAST([REDACTED].[dbo].[REDACTED].[MSISDN] AS bigint)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="TRY_CAST([REDACTED].[dbo].[REDACTED].[MSISDN] AS bigint)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="TRY_CAST([REDACTED].[dbo].[REDACTED].[MSISDN] AS bigint)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="TRY_CAST([REDACTED].[dbo].[REDACTED].[MSISDN] AS bigint)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="TRY_CAST([REDACTED].[dbo].[REDACTED].[MSISDN] AS bigint)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(numeric(18,0),[Union1041],0)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(100),[Union1018],0)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)" />
<PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)=[Union1014]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)=[Union1014]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)=[Union1014]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)=[Union1014]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(numeric(18,0),[REDACTED].[dbo].[REDACTED].[REDACTED],0)=[Union1014]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(100),[cdip].[REDACTED],0)=[m].[REDACTED]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(100),[cdip].[REDACTED],0)=[m].[REDACTED]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(100),[cdip].[REDACTED],0)=[m].[REDACTED]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(100),[cdb].[REDACTED],0)=[m].[REDACTED]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(100),[cda].[REDACTED],0)=[m].[REDACTED]" />
<PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(100),[cdwp].[REDACTED],0)=[m].[REDACTED]" />
</Warnings>
<MemoryGrantInfo SerialRequiredMemory="3072" SerialDesiredMemory="19284432" RequiredMemory="13680" DesiredMemory="19295056" RequestedMemory="12640256" GrantWaitTime="0" GrantedMemory="12640256" MaxUsedMemory="5083472" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1677721" EstimatedPagesCached="419430" EstimatedAvailableDegreeOfParallelism="2" />
<RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="159878" EstimateIO="0" EstimateCPU="0.0159878" AvgRowSize="69" EstimatedTotalSubtreeCost="7638.38" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1057" />
<ColumnReference Column="Expr1058" />
<ColumnReference Column="Expr1059" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1058" />
<ScalarOperator ScalarString="ScalarString1">
<Identifier>
<ColumnReference Column="Column1">
<ScalarOperator>
<Convert DataType="date" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1059" />
<ScalarOperator ScalarString="ScalarString2">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1056" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column3" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="159878" EstimateIO="0" EstimateCPU="0.0159878" AvgRowSize="56" EstimatedTotalSubtreeCost="7638.37" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Expr1057" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1057" />
<ScalarOperator ScalarString="ScalarString3">
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="globalagg1074" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="3" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="159878" EstimateIO="0" EstimateCPU="0.52576" AvgRowSize="60" EstimatedTotalSubtreeCost="7638.35" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="globalagg1074" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="25" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Parallelism>
<RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="159878" EstimateIO="0" EstimateCPU="4.94221" AvgRowSize="60" EstimatedTotalSubtreeCost="7637.83" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="globalagg1074" />
</OutputList>
<MemoryFractions Input="0.00120365" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="globalagg1074" />
<ScalarOperator ScalarString="ScalarString4">
<Aggregate Distinct="0" AggType="SUM">
<ScalarOperator>
<Identifier>
<ColumnReference Column="partialagg1073" />
</Identifier>
</ScalarOperator>
</Aggregate>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
</HashKeysBuild>
<BuildResidual>
<ScalarOperator ScalarString="ScalarString5">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1042" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1042" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1056" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1056" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</BuildResidual>
<RelOp NodeId="5" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="319755" EstimateIO="0" EstimateCPU="1.41572" AvgRowSize="60" EstimatedTotalSubtreeCost="7632.88" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="partialagg1073" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="28" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="44" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="24" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
</PartitionColumns>
<RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="319755" EstimateIO="0" EstimateCPU="393.843" AvgRowSize="60" EstimatedTotalSubtreeCost="7631.47" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="partialagg1073" />
</OutputList>
<MemoryFractions Input="0.00245999" Output="0.998796" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="25" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="25" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="25" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="25" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="partialagg1073" />
<ScalarOperator ScalarString="ScalarString6">
<Aggregate Distinct="0" AggType="COUNT*" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<HashKeysBuild>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
</HashKeysBuild>
<BuildResidual>
<ScalarOperator ScalarString="ScalarString5">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1042" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1042" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1056" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1056" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</BuildResidual>
<RelOp NodeId="7" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1.13471e+008" EstimateIO="1906.67" EstimateCPU="3222.34" AvgRowSize="52" EstimatedTotalSubtreeCost="7237.63" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.82882" Output="0.99754" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="563439" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="564016" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="563856" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="564256" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Union1049" />
</HashKeysBuild>
<BuildResidual>
<ScalarOperator ScalarString="ScalarString7">
<Logical Operation="AND">
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1042" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1042" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1056" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1056" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1049" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1049" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</BuildResidual>
<RelOp NodeId="8" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="1.13471e+008" EstimateIO="0" EstimateCPU="517.753" AvgRowSize="60" EstimatedTotalSubtreeCost="2108.62" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Union1049" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="4690529" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="4672514" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="4679500" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="4677533" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Union1049" />
</PartitionColumns>
<RelOp NodeId="9" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.13471e+008" EstimateIO="0" EstimateCPU="481.448" AvgRowSize="60" EstimatedTotalSubtreeCost="1590.86" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Union1049" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.968368" Output="0.17118" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="4682969" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="4677073" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="4675694" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="4684340" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Column="Union1014" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Expr1072" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString8">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1072" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1014" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="10" PhysicalOp="Hash Match" LogicalOp="Right Anti Semi Join" EstimateRows="9.04135e+006" EstimateIO="0" EstimateCPU="41.7648" AvgRowSize="27" EstimatedTotalSubtreeCost="328.77" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1014" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.993767" Output="0.0314353" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="2054153" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="2055390" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="2056141" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="2054907" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Union1014" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString9">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1014" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="11" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="213092" EstimateIO="0" EstimateCPU="0.34694" AvgRowSize="16" EstimatedTotalSubtreeCost="3.7649" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="70875" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="71110" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="71042" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="70911" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</PartitionColumns>
<RelOp NodeId="12" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="213092" EstimateIO="0" EstimateCPU="0.157207" AvgRowSize="16" EstimatedTotalSubtreeCost="3.41796" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="63613" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="75805" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="77332" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="67188" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<StreamAggregate>
<DefinedValues />
<GroupBy>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</GroupBy>
<RelOp NodeId="13" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="415737" EstimateIO="3.03201" EstimateCPU="0.228734" AvgRowSize="16" EstimatedTotalSubtreeCost="3.26075" TableCardinality="415737" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="93436" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="110519" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="113399" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="98383" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table1" Alias="Alias1" Column="Column4" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table1" Index="Index1" Alias="Alias1" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</StreamAggregate>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="15" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="9.20572e+006" EstimateIO="0" EstimateCPU="0.487481" AvgRowSize="27" EstimatedTotalSubtreeCost="283.24" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1014" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="2131768" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="2133004" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="2133749" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="2132395" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Union1014" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Expr1056" />
<ColumnReference Column="Expr1056" />
</DefinedValue>
</DefinedValues>
<RelOp NodeId="16" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="5.36033e+006" EstimateIO="0" EstimateCPU="0.0285042" AvgRowSize="27" EstimatedTotalSubtreeCost="145.434" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="1172473" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="1171569" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1173943" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="1172304" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column4" />
</PartitionColumns>
<RelOp NodeId="17" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="5.36033e+006" EstimateIO="0" EstimateCPU="21.2948" AvgRowSize="27" EstimatedTotalSubtreeCost="145.405" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.00623284" Output="0.00019716" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="1462069" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="879674" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="1240640" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1107906" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Expr1066" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString10">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1066" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="18" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="8" EstimateIO="0" EstimateCPU="0.028531" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0318226" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp NodeId="19" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8" EstimateIO="0" EstimateCPU="8e-007" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0032916" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1056" />
<ScalarOperator ScalarString="ScalarString11">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value1" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value2" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value3" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value4" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value5" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value6" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value7" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value8" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value9" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value10" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="Value11" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="20" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table8" Index="Index2" Alias="Alias6" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.69029e+006" EstimateIO="0" EstimateCPU="0.234514" AvgRowSize="26" EstimatedTotalSubtreeCost="124.079" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1066" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1066" />
<ScalarOperator ScalarString="ScalarString12">
<Convert DataType="nvarchar" Length="200" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column5" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="25" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="4.69029e+006" EstimateIO="121.265" EstimateCPU="2.57974" AvgRowSize="26" EstimatedTotalSubtreeCost="123.844" TableCardinality="4.69029e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="1462069" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="879674" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="1240640" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1107906" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table2" Alias="Alias2" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table2" Index="Index3" Alias="Alias2" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="30" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="1.46353e+006" EstimateIO="0" EstimateCPU="0.0285042" AvgRowSize="27" EstimatedTotalSubtreeCost="21.4167" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="318956" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="320926" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="320300" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="320408" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column4" />
</PartitionColumns>
<RelOp NodeId="31" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1.46353e+006" EstimateIO="0" EstimateCPU="3.8149" AvgRowSize="27" EstimatedTotalSubtreeCost="21.3882" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.00019716" Output="0.00019716" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="314200" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="327126" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="315260" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="324004" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Expr1067" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString13">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1067" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="32" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="8" EstimateIO="0" EstimateCPU="0.028531" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0318226" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp NodeId="33" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8" EstimateIO="0" EstimateCPU="8e-007" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0032916" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1056" />
<ScalarOperator ScalarString="ScalarString11">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value1" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value2" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value3" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value4" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value5" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value6" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value7" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value8" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value9" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value10" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="Value11" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="34" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table8" Index="Index2" Alias="Alias6" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="38" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="640295" EstimateIO="0" EstimateCPU="0.0320148" AvgRowSize="24" EstimatedTotalSubtreeCost="17.5415" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1067" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1067" />
<ScalarOperator ScalarString="ScalarString14">
<Convert DataType="nvarchar" Length="200" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column5" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="39" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="640295" EstimateIO="17.1572" EstimateCPU="0.352241" AvgRowSize="24" EstimatedTotalSubtreeCost="17.5094" TableCardinality="640295" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="157100" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="157630" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="163563" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="162002" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table3" Alias="Alias2" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table3" Index="Index4" Alias="Alias2" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="44" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="122113" EstimateIO="0" EstimateCPU="0.0285042" AvgRowSize="27" EstimatedTotalSubtreeCost="3.37636" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="26475" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="26712" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="26648" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="27014" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column4" />
</PartitionColumns>
<RelOp NodeId="45" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="122113" EstimateIO="0" EstimateCPU="0.502787" AvgRowSize="27" EstimatedTotalSubtreeCost="3.34785" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.00019716" Output="0.00019716" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="27211" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="26553" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="26984" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="26101" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Expr1068" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString15">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1068" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="46" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="8" EstimateIO="0" EstimateCPU="0.028531" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0318226" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp NodeId="47" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8" EstimateIO="0" EstimateCPU="8e-007" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0032916" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1056" />
<ScalarOperator ScalarString="ScalarString11">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value1" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value2" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value3" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value4" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value5" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value6" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value7" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value8" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value9" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value10" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="Value11" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="48" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table8" Index="Index2" Alias="Alias6" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="52" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="106849" EstimateIO="0" EstimateCPU="0.00534245" AvgRowSize="24" EstimatedTotalSubtreeCost="2.81324" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column4" />
<ColumnReference Column="Expr1068" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1068" />
<ScalarOperator ScalarString="ScalarString16">
<Convert DataType="nvarchar" Length="200" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column5" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="53" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="106849" EstimateIO="2.74905" EstimateCPU="0.0588455" AvgRowSize="24" EstimatedTotalSubtreeCost="2.8079" TableCardinality="106849" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="27211" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="26553" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="26984" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="26101" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table4" Alias="Alias2" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table4" Index="Index5" Alias="Alias2" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="58" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="481408" EstimateIO="0" EstimateCPU="0.0285042" AvgRowSize="27" EstimatedTotalSubtreeCost="15.5519" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="105474" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="105258" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="105350" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="105150" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column4" />
</PartitionColumns>
<RelOp NodeId="59" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="481408" EstimateIO="0" EstimateCPU="1.92893" AvgRowSize="27" EstimatedTotalSubtreeCost="15.5234" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.00019716" Output="0.00019716" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="102660" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="109156" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="104057" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="105359" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Expr1069" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString17">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1069" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="60" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="8" EstimateIO="0" EstimateCPU="0.028531" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0318226" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp NodeId="61" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8" EstimateIO="0" EstimateCPU="8e-007" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0032916" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1056" />
<ScalarOperator ScalarString="ScalarString11">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value1" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value2" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value3" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value4" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value5" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value6" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value7" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value8" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value9" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value10" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="Value11" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="62" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table8" Index="Index2" Alias="Alias6" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="66" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="421232" EstimateIO="0" EstimateCPU="0.0210616" AvgRowSize="30" EstimatedTotalSubtreeCost="13.5626" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column4" />
<ColumnReference Column="Expr1069" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1069" />
<ScalarOperator ScalarString="ScalarString18">
<Convert DataType="nvarchar" Length="200" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column5" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="67" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="421232" EstimateIO="13.3098" EstimateCPU="0.231756" AvgRowSize="30" EstimatedTotalSubtreeCost="13.5415" TableCardinality="421232" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="104057" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="102660" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="105359" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="109156" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table5" Alias="Alias3" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table5" Index="Index6" Alias="Alias3" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="72" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="2.14863e+006" EstimateIO="0" EstimateCPU="0.0285042" AvgRowSize="27" EstimatedTotalSubtreeCost="91.8648" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="470544" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="470545" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="469406" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="469555" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column4" />
</PartitionColumns>
<RelOp NodeId="73" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="2.14863e+006" EstimateIO="0" EstimateCPU="8.54661" AvgRowSize="27" EstimatedTotalSubtreeCost="91.8363" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.00019716" Output="0.00019716" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="407367" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="660679" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="410953" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="401051" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Expr1070" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString19">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1070" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="74" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="8" EstimateIO="0" EstimateCPU="0.028531" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0318226" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp NodeId="75" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8" EstimateIO="0" EstimateCPU="8e-007" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0032916" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1056" />
<ScalarOperator ScalarString="ScalarString11">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value1" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value2" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value3" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value4" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value5" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value6" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value7" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value8" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value9" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value10" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="Value11" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="76" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table8" Index="Index2" Alias="Alias6" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="80" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.88005e+006" EstimateIO="0" EstimateCPU="0.0940025" AvgRowSize="27" EstimatedTotalSubtreeCost="83.2579" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column4" />
<ColumnReference Column="Expr1070" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1070" />
<ScalarOperator ScalarString="ScalarString20">
<Convert DataType="nvarchar" Length="200" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column5" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="81" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.88005e+006" EstimateIO="82.1298" EstimateCPU="1.03411" AvgRowSize="27" EstimatedTotalSubtreeCost="83.1639" TableCardinality="1.88005e+006" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="407367" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="660679" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="410953" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="401051" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table6" Alias="Alias4" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table6" Index="Index7" Alias="Alias4" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="86" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="173607" EstimateIO="0" EstimateCPU="0.0285042" AvgRowSize="27" EstimatedTotalSubtreeCost="5.10926" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="37846" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="37994" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="38102" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="37964" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column4" />
</PartitionColumns>
<RelOp NodeId="87" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="173607" EstimateIO="0" EstimateCPU="0.70718" AvgRowSize="27" EstimatedTotalSubtreeCost="5.08076" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column4" />
<ColumnReference Column="Expr1056" />
</OutputList>
<MemoryFractions Input="0.00019716" Output="0.00019716" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="39254" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="37463" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="37071" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="38118" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Expr1071" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="ScalarString21">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1071" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp NodeId="88" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="8" EstimateIO="0" EstimateCPU="0.028531" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0318226" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp NodeId="89" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8" EstimateIO="0" EstimateCPU="8e-007" AvgRowSize="33" EstimatedTotalSubtreeCost="0.0032916" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
<ColumnReference Column="Expr1056" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1056" />
<ScalarOperator ScalarString="ScalarString11">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value1" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value2" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value3" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value4" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value5" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value6" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value7" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value8" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value9" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="Value10" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="Value11" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="90" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="8" EstimateIO="0.003125" EstimateCPU="0.0001658" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table8" Alias="Alias6" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table8" Index="Index2" Alias="Alias6" IndexKind="NonClustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
<RelOp NodeId="94" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="151906" EstimateIO="0" EstimateCPU="0.0075953" AvgRowSize="33" EstimatedTotalSubtreeCost="4.34175" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column4" />
<ColumnReference Column="Expr1071" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1071" />
<ScalarOperator ScalarString="ScalarString22">
<Convert DataType="nvarchar" Length="200" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column5" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="95" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="151906" EstimateIO="4.25053" EstimateCPU="0.0836268" AvgRowSize="33" EstimatedTotalSubtreeCost="4.33416" TableCardinality="151906" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column4" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column5" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="39254" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="37463" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="37071" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="38118" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column4" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table7" Alias="Alias5" Column="Column5" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table7" Index="Index8" Alias="Alias5" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</Concat>
</RelOp>
</Hash>
</RelOp>
<RelOp NodeId="101" PhysicalOp="Parallelism" LogicalOp="Repartition Streams" EstimateRows="7.75368e+007" EstimateIO="0" EstimateCPU="271.049" AvgRowSize="60" EstimatedTotalSubtreeCost="780.645" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Union1049" />
<ColumnReference Column="Expr1072" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="4757988" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="4750522" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="4745975" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="4757147" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Column="Expr1072" />
</PartitionColumns>
<RelOp NodeId="102" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="7.75368e+007" EstimateIO="0" EstimateCPU="3.87684" AvgRowSize="60" EstimatedTotalSubtreeCost="509.596" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1042" />
<ColumnReference Column="Union1049" />
<ColumnReference Column="Expr1072" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1072" />
<ScalarOperator ScalarString="ScalarString23">
<Convert DataType="numeric" Precision="18" Scale="0" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Union1041" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="103" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="7.75368e+007" EstimateIO="0" EstimateCPU="3.87684" AvgRowSize="85" EstimatedTotalSubtreeCost="505.719" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1041" />
<ColumnReference Column="Union1042" />
<ColumnReference Column="Union1049" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4828443" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="4590929" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="4839918" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="4752342" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Union1041" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column7" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1042" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column8" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1049" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</DefinedValue>
</DefinedValues>
<RelOp NodeId="104" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.30509e+007" EstimateIO="0" EstimateCPU="0.652543" AvgRowSize="36" EstimatedTotalSubtreeCost="89.8066" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="1">
<RelOp NodeId="105" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.30509e+007" EstimateIO="0" EstimateCPU="0.652543" AvgRowSize="36" EstimatedTotalSubtreeCost="89.8066" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
<ScalarOperator ScalarString="ScalarString24">
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="106" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.30509e+007" EstimateIO="74.4194" EstimateCPU="8.18597" AvgRowSize="36" EstimatedTotalSubtreeCost="82.6054" TableCardinality="7.4009e+008" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column7" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column8" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table9" Index="Index9" Filtered="1" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column10" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString25">
<Const ConstValue="Value12" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString26">
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString27">
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="ScalarString28">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table9" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="ScalarString29">
<Identifier>
<ColumnReference Column="Column13">
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value14" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value15" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp NodeId="111" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.50827e+007" EstimateIO="0" EstimateCPU="0.754137" AvgRowSize="36" EstimatedTotalSubtreeCost="96.7549" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="1">
<RelOp NodeId="112" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.50827e+007" EstimateIO="0" EstimateCPU="0.754137" AvgRowSize="36" EstimatedTotalSubtreeCost="96.7549" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
<ScalarOperator ScalarString="ScalarString30">
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="113" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.50827e+007" EstimateIO="79.075" EstimateCPU="9.40324" AvgRowSize="36" EstimatedTotalSubtreeCost="88.4782" TableCardinality="9.1459e+008" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column7" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column8" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table10" Index="Index10" Filtered="1" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column10" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString25">
<Const ConstValue="Value12" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString26">
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString27">
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="ScalarString31">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table10" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="ScalarString32">
<Identifier>
<ColumnReference Column="Column14">
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value16" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value17" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp NodeId="118" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.6609e+007" EstimateIO="0" EstimateCPU="0.830452" AvgRowSize="36" EstimatedTotalSubtreeCost="111.225" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="1">
<RelOp NodeId="119" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.6609e+007" EstimateIO="0" EstimateCPU="0.830452" AvgRowSize="36" EstimatedTotalSubtreeCost="111.225" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
<ScalarOperator ScalarString="ScalarString33">
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="120" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.6609e+007" EstimateIO="91.6091" EstimateCPU="10.4365" AvgRowSize="36" EstimatedTotalSubtreeCost="102.046" TableCardinality="9.67355e+008" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column7" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column8" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table11" Index="Index11" Filtered="1" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column10" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString25">
<Const ConstValue="Value12" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString26">
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString27">
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="ScalarString34">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table11" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="ScalarString35">
<Identifier>
<ColumnReference Column="Column15">
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value18" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value19" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp NodeId="125" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.80707e+007" EstimateIO="0" EstimateCPU="0.903533" AvgRowSize="41" EstimatedTotalSubtreeCost="116.767" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="1">
<RelOp NodeId="126" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.80707e+007" EstimateIO="0" EstimateCPU="0.903533" AvgRowSize="41" EstimatedTotalSubtreeCost="116.767" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
<ScalarOperator ScalarString="ScalarString36">
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="127" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.80707e+007" EstimateIO="95.0794" EstimateCPU="11.5467" AvgRowSize="41" EstimatedTotalSubtreeCost="106.626" TableCardinality="1.00043e+009" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column7" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column8" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table12" Index="Index12" Filtered="1" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column10" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString25">
<Const ConstValue="Value12" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString26">
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString27">
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="ScalarString37">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table12" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="ScalarString38">
<Identifier>
<ColumnReference Column="Column16">
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value20" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value21" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp NodeId="132" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.47235e+007" EstimateIO="0" EstimateCPU="0.736176" AvgRowSize="41" EstimatedTotalSubtreeCost="87.2888" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4828443" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="4590929" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="4839918" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="4752342" Batches="0" ActualExecutionMode="Row" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="1">
<RelOp NodeId="133" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.47235e+007" EstimateIO="0" EstimateCPU="0.736176" AvgRowSize="41" EstimatedTotalSubtreeCost="87.2888" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
<ScalarOperator ScalarString="ScalarString39">
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="134" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.47235e+007" EstimateIO="69.7779" EstimateCPU="9.3193" AvgRowSize="41" EstimatedTotalSubtreeCost="79.0972" TableCardinality="8.66095e+008" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column7" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column8" />
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="4828443" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="4590929" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="4839918" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="4752342" Batches="0" ActualExecutionMode="Row" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column7" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column8" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</DefinedValue>
</DefinedValues>
<Object Database="Database1" Schema="Schema1" Table="Table13" Index="Index13" Filtered="1" IndexKind="NonClustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column10" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString25">
<Const ConstValue="Value12" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString26">
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LE">
<RangeColumns>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column11" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="ScalarString27">
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="ScalarString40">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="Database1" Schema="Schema1" Table="Table13" Column="Column9" ComputedColumn="1" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value13" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="ScalarString41">
<Identifier>
<ColumnReference Column="Column17">
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column12" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value22" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Column2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="Value23" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Concat>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
</ComputeScalar>
</RelOp>
<ParameterList>
<ColumnReference Column="Column3" ParameterRuntimeValue="Value1" />
<ColumnReference Column="Column2" ParameterRuntimeValue="Value2" />
<ColumnReference Column="Column12" ParameterRuntimeValue="Value3" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment