Created
March 11, 2014 08:43
-
-
Save codingbadger/9481785 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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