Created
June 29, 2020 14:45
-
-
Save jadarnel27/528e8a1878d464c3a1e8b9d042c45e7b to your computer and use it in GitHub Desktop.
Serial-Parallel-Plan
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:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.518" Build="13.0.5102.14" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="1" StatementEstRows="5683580" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="130" StatementSubTreeCost="6821.74" StatementText="SELECT *
INTO #TEMP
FROM Table1 WITH (FORCESEEK)
WHERE IntField1 = 157
 AND DateField1 >= '1918-02-19'" StatementType="SELECT INTO" QueryHash="0xA7A8162BBD6386C1" QueryPlanHash="0x9147151587CAA05C" RetrievedFromCache="true" SecurityPolicyApplied="false"> | |
| <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> | |
| <QueryPlan DegreeOfParallelism="8" MemoryGrant="268808" CachedPlanSize="72" CompileTime="1" CompileCPU="1" CompileMemory="408"> | |
| <ThreadStat Branches="1" UsedThreads="8"> | |
| <ThreadReservation NodeId="0" ReservedThreads="9" /> | |
| </ThreadStat> | |
| <MissingIndexes> | |
| <MissingIndexGroup Impact="99.0524"> | |
| <MissingIndex Database="[269888]" Schema="[dbo]" Table="[Table1]"> | |
| <ColumnGroup Usage="EQUALITY"> | |
| <Column Name="[IntField1]" ColumnId="2" /> | |
| </ColumnGroup> | |
| <ColumnGroup Usage="INEQUALITY"> | |
| <Column Name="[DateField1]" ColumnId="4" /> | |
| </ColumnGroup> | |
| <ColumnGroup Usage="INCLUDE"> | |
| <Column Name="[Id]" ColumnId="1" /> | |
| <Column Name="[IntField2]" ColumnId="3" /> | |
| <Column Name="[IntField3]" ColumnId="5" /> | |
| <Column Name="[IntField4]" ColumnId="6" /> | |
| </ColumnGroup> | |
| </MissingIndex> | |
| </MissingIndexGroup> | |
| </MissingIndexes> | |
| <MemoryGrantInfo SerialRequiredMemory="144" SerialDesiredMemory="267608" RequiredMemory="1288" DesiredMemory="268808" RequestedMemory="268808" GrantWaitTime="0" GrantedMemory="268808" MaxUsedMemory="178944" MaxQueryMemory="1744456" /> | |
| <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="157286" EstimatedPagesCached="78643" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="7834872" /> | |
| <OptimizerStatsUsage> | |
| <StatisticsInfo Database="[269888]" Schema="[dbo]" Table="[Table1]" Statistics="[_WA_Sys_00000004_36B12243]" ModificationCount="0" SamplingPercent="0.235928" LastUpdate="2020-06-29T09:48:56.38" /> | |
| <StatisticsInfo Database="[269888]" Schema="[dbo]" Table="[Table1]" Statistics="[IX_Table1_1]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-06-29T09:48:04.84" /> | |
| </OptimizerStatsUsage> | |
| <WaitStats> | |
| <Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="8" WaitCount="11797" /> | |
| <Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="53" WaitCount="10859" /> | |
| <Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="82" WaitCount="4669" /> | |
| <Wait WaitType="PAGELATCH_UP" WaitTimeMs="83" WaitCount="2596" /> | |
| <Wait WaitType="LATCH_EX" WaitTimeMs="195" WaitCount="5871" /> | |
| <Wait WaitType="BPSORT" WaitTimeMs="231" WaitCount="209" /> | |
| <Wait WaitType="CXPACKET" WaitTimeMs="559" WaitCount="9" /> | |
| </WaitStats> | |
| <QueryTimeStats CpuTime="17457" ElapsedTime="13537" /> | |
| <RelOp AvgRowSize="9" EstimateCPU="1.80817" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="6821.74"> | |
| <OutputList /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="5381352" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="13364" ActualCPUms="169" /> | |
| </RunTimeInformation> | |
| <Parallelism> | |
| <RelOp AvgRowSize="9" EstimateCPU="1.4209" EstimateIO="35.1594" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Insert" NodeId="1" Parallel="true" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="6819.93"> | |
| <OutputList /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="593" ActualCPUms="503" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="593" ActualCPUms="518" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="582" ActualCPUms="500" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="593" ActualCPUms="523" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="593" ActualCPUms="517" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="593" ActualCPUms="528" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="593" ActualCPUms="524" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="5381352" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="13058" ActualCPUms="13017" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <Update DMLRequestSort="false"> | |
| <Object Table="[#TEMP]" Storage="RowStore" /> | |
| <SetPredicate> | |
| <ScalarOperator ScalarString="[#TEMP].[Id] = [Expr1005],[#TEMP].[IntField1] = [269888].[dbo].[Table1].[IntField1],[#TEMP].[IntField2] = [269888].[dbo].[Table1].[IntField2],[#TEMP].[DateField1] = [269888].[dbo].[Table1].[DateField1],[#TEMP].[IntField3] = [269888].[dbo].[Table1].[IntField3],[#TEMP].[IntField4] = [269888].[dbo].[Table1].[IntField4]"> | |
| <ScalarExpressionList> | |
| <ScalarOperator> | |
| <MultipleAssign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="Id" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="Expr1005" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField1" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField2" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="DateField1" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField3" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField4" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| </MultipleAssign> | |
| </ScalarOperator> | |
| </ScalarExpressionList> | |
| </ScalarOperator> | |
| </SetPredicate> | |
| <RelOp AvgRowSize="30" EstimateCPU="0.14209" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Compute Scalar" NodeId="2" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="6783.35"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| <ColumnReference Column="Expr1005" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1005" /> | |
| <ScalarOperator ScalarString="setidentity([269888].[dbo].[Table1].[Id],(-7),(0),N'#TEMP')"> | |
| <Intrinsic FunctionName="setidentity"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(-7)" /> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(0)" /> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="N'#TEMP'" /> | |
| </ScalarOperator> | |
| </Intrinsic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="30" EstimateCPU="5.93934" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Inner Join" NodeId="3" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6783.21"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="546" ActualCPUms="494" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="546" ActualCPUms="509" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="546" ActualCPUms="493" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="546" ActualCPUms="514" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="546" ActualCPUms="507" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="546" ActualCPUms="519" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="546" ActualCPUms="515" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="5381352" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="10510" ActualCPUms="10479" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="false" WithUnorderedPrefetch="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Column="Expr1006" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="22" EstimateCPU="5.3319" EstimateIO="31.9388" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch" EstimateRows="5683580" LogicalOp="Sort" NodeId="5" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="50.9084"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </OutputList> | |
| <MemoryFractions Input="1" Output="1" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="255" ActualCPUms="214" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="296" ActualCPUms="251" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="270" ActualCPUms="231" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="244" ActualCPUms="236" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="261" ActualCPUms="222" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="265" ActualCPUms="236" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="294" ActualCPUms="253" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="5381352" Batches="5980" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch" ActualElapsedms="341" ActualCPUms="296" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
| </RunTimeInformation> | |
| <Sort Distinct="false"> | |
| <OrderBy> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </OrderByColumn> | |
| </OrderBy> | |
| <RelOp AvgRowSize="22" EstimateCPU="1.56302" EstimateIO="10.9379" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" EstimatedRowsRead="5683580" LogicalOp="Index Seek" NodeId="6" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="12.501" TableCardinality="500000000"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="622160" ActualRowsRead="622160" Batches="692" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="255" ActualCPUms="255" ActualScans="1" ActualLogicalReads="1640" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="622160" ActualRowsRead="622160" Batches="692" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="239" ActualCPUms="239" ActualScans="1" ActualLogicalReads="1640" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="559612" ActualRowsRead="559612" Batches="622" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="268" ActualCPUms="248" ActualScans="1" ActualLogicalReads="1477" ActualPhysicalReads="0" ActualReadAheads="79" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="777700" ActualRowsRead="777700" Batches="865" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="271" ActualCPUms="271" ActualScans="1" ActualLogicalReads="2050" ActualPhysicalReads="0" ActualReadAheads="28" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="777700" ActualRowsRead="777700" Batches="865" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="284" ActualCPUms="284" ActualScans="1" ActualLogicalReads="2050" ActualPhysicalReads="0" ActualReadAheads="135" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="777700" ActualRowsRead="777700" Batches="865" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="277" ActualCPUms="277" ActualScans="1" ActualLogicalReads="2050" ActualPhysicalReads="0" ActualReadAheads="136" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="622160" ActualRowsRead="622160" Batches="692" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="235" ActualCPUms="235" ActualScans="1" ActualLogicalReads="1640" ActualPhysicalReads="0" ActualReadAheads="189" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="622160" ActualRowsRead="622160" Batches="692" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="249" ActualCPUms="249" ActualScans="1" ActualLogicalReads="1640" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[269888]" Schema="[dbo]" Table="[Table1]" Index="[IX_Table1_1]" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="(157)"> | |
| <Const ConstValue="(157)" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| <StartRange ScanType="GE"> | |
| <RangeColumns> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'1918-02-19'"> | |
| <Const ConstValue="'1918-02-19'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </StartRange> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </Sort> | |
| </RelOp> | |
| <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="5683580" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="8" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="6726.36" TableCardinality="500000000"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="5381352" ActualRowsRead="5381352" Batches="0" ActualEndOfScans="0" ActualExecutions="5381352" ActualExecutionMode="Row" ActualElapsedms="7446" ActualCPUms="7446" ActualScans="0" ActualLogicalReads="20516379" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[269888]" Schema="[dbo]" Table="[Table1]" Index="[PK_Table1]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[269888].[dbo].[Table1].[Id]"> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| </Update> | |
| </RelOp> | |
| </Parallelism> | |
| </RelOp> | |
| </QueryPlan> | |
| </StmtSimple> | |
| </Statements> | |
| </Batch> | |
| </BatchSequence> | |
| </ShowPlanXML> |
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:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.518" Build="13.0.5102.14" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="1" StatementEstRows="5683580" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="130" StatementSubTreeCost="6932.46" StatementText="SELECT *
INTO #TEMP
FROM Table1 WITH (FORCESEEK)
WHERE IntField1 = 157
 AND DateField1 >= '1918-02-19'" StatementType="SELECT INTO" QueryHash="0xA7A8162BBD6386C1" QueryPlanHash="0x9147151587CAA05C" RetrievedFromCache="true" SecurityPolicyApplied="false"> | |
| <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> | |
| <QueryPlan DegreeOfParallelism="8" MemoryGrant="435528" CachedPlanSize="72" CompileTime="11" CompileCPU="11" CompileMemory="352"> | |
| <ThreadStat Branches="1" UsedThreads="8"> | |
| <ThreadReservation NodeId="0" ReservedThreads="8" /> | |
| </ThreadStat> | |
| <MissingIndexes> | |
| <MissingIndexGroup Impact="99.0675"> | |
| <MissingIndex Database="[269888]" Schema="[dbo]" Table="[Table1]"> | |
| <ColumnGroup Usage="EQUALITY"> | |
| <Column Name="[IntField1]" ColumnId="2" /> | |
| </ColumnGroup> | |
| <ColumnGroup Usage="INEQUALITY"> | |
| <Column Name="[DateField1]" ColumnId="4" /> | |
| </ColumnGroup> | |
| <ColumnGroup Usage="INCLUDE"> | |
| <Column Name="[Id]" ColumnId="1" /> | |
| <Column Name="[IntField2]" ColumnId="3" /> | |
| <Column Name="[IntField3]" ColumnId="5" /> | |
| <Column Name="[IntField4]" ColumnId="6" /> | |
| </ColumnGroup> | |
| </MissingIndex> | |
| </MissingIndexGroup> | |
| </MissingIndexes> | |
| <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="431760" RequiredMemory="4232" DesiredMemory="435528" RequestedMemory="435528" GrantWaitTime="0" GrantedMemory="435528" MaxUsedMemory="347592" MaxQueryMemory="1834712" /> | |
| <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="157286" EstimatedPagesCached="78643" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="8313344" /> | |
| <OptimizerStatsUsage> | |
| <StatisticsInfo Database="[269888]" Schema="[dbo]" Table="[Table1]" Statistics="[_WA_Sys_00000004_36B12243]" ModificationCount="0" SamplingPercent="0.235928" LastUpdate="2020-06-29T09:48:56.38" /> | |
| <StatisticsInfo Database="[269888]" Schema="[dbo]" Table="[Table1]" Statistics="[IX_Table1_1]" ModificationCount="0" SamplingPercent="100" LastUpdate="2020-06-29T09:48:04.84" /> | |
| </OptimizerStatsUsage> | |
| <WaitStats> | |
| <Wait WaitType="LATCH_SH" WaitTimeMs="1" WaitCount="8" /> | |
| <Wait WaitType="CXROWSET_SYNC" WaitTimeMs="2" WaitCount="14" /> | |
| <Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="4" WaitCount="2340" /> | |
| <Wait WaitType="IO_COMPLETION" WaitTimeMs="13" WaitCount="16" /> | |
| <Wait WaitType="PAGELATCH_UP" WaitTimeMs="20" WaitCount="8" /> | |
| <Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="59" WaitCount="43449" /> | |
| <Wait WaitType="LATCH_EX" WaitTimeMs="231" WaitCount="61" /> | |
| <Wait WaitType="CXPACKET" WaitTimeMs="1849" WaitCount="125" /> | |
| <Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="2385" WaitCount="9681" /> | |
| </WaitStats> | |
| <QueryTimeStats CpuTime="35856" ElapsedTime="5488" /> | |
| <RelOp AvgRowSize="9" EstimateCPU="1.80817" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="6932.46"> | |
| <OutputList /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="5381352" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5073" ActualCPUms="275" /> | |
| </RunTimeInformation> | |
| <Parallelism> | |
| <RelOp AvgRowSize="9" EstimateCPU="1.4209" EstimateIO="35.1594" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Insert" NodeId="1" Parallel="true" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="6930.65"> | |
| <OutputList /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5297" ActualCPUms="4300" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4862" ActualCPUms="4727" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4424" ActualCPUms="4156" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="466620" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4124" ActualCPUms="3625" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4378" ActualCPUms="4146" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="563717" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4272" ActualCPUms="3990" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="773595" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4728" ActualCPUms="4645" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4818" ActualCPUms="4738" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <Update DMLRequestSort="false"> | |
| <Object Table="[#TEMP]" Storage="RowStore" /> | |
| <SetPredicate> | |
| <ScalarOperator ScalarString="[#TEMP].[Id] = [Expr1005],[#TEMP].[IntField1] = [269888].[dbo].[Table1].[IntField1],[#TEMP].[IntField2] = [269888].[dbo].[Table1].[IntField2],[#TEMP].[DateField1] = [269888].[dbo].[Table1].[DateField1],[#TEMP].[IntField3] = [269888].[dbo].[Table1].[IntField3],[#TEMP].[IntField4] = [269888].[dbo].[Table1].[IntField4]"> | |
| <ScalarExpressionList> | |
| <ScalarOperator> | |
| <MultipleAssign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="Id" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="Expr1005" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField1" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField2" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="DateField1" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField3" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| <Assign> | |
| <ColumnReference Table="[#TEMP]" Column="IntField4" /> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Assign> | |
| </MultipleAssign> | |
| </ScalarOperator> | |
| </ScalarExpressionList> | |
| </ScalarOperator> | |
| </SetPredicate> | |
| <RelOp AvgRowSize="30" EstimateCPU="0.14209" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Compute Scalar" NodeId="2" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="6894.07"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| <ColumnReference Column="Expr1005" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1005" /> | |
| <ScalarOperator ScalarString="setidentity([269888].[dbo].[Table1].[Id],(-7),(0),N'#TEMP')"> | |
| <Intrinsic FunctionName="setidentity"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(-7)" /> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(0)" /> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="N'#TEMP'" /> | |
| </ScalarOperator> | |
| </Intrinsic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="30" EstimateCPU="5.93934" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Inner Join" NodeId="3" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6893.93"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4716" ActualCPUms="3746" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4226" ActualCPUms="4113" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3840" ActualCPUms="3607" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="466620" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3308" ActualCPUms="2859" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3806" ActualCPUms="3600" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="563717" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3611" ActualCPUms="3360" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="773595" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4094" ActualCPUms="4040" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4189" ActualCPUms="4133" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="false" WithUnorderedPrefetch="true"> | |
| <OuterReferences> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Column="Expr1006" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="22" EstimateCPU="53.3188" EstimateIO="95.8164" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" LogicalOp="Sort" NodeId="5" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="161.636"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </OutputList> | |
| <Warnings> | |
| <SpillToTempDb SpillLevel="1" SpilledThreadCount="4" /> | |
| <SortSpillDetails GrantedMemoryKb="217696" UsedMemoryKb="217696" WritesToTempDb="7290" ReadsFromTempDb="7290" /> | |
| </Warnings> | |
| <MemoryFractions Input="1" Output="1" /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1598" ActualCPUms="1107" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="1827" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="54424" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1237" ActualCPUms="1142" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="1827" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="54424" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1216" ActualCPUms="998" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="35488" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="466620" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1117" ActualCPUms="786" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="26624" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1138" ActualCPUms="958" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="35488" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="563717" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1174" ActualCPUms="936" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="32160" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="773595" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1177" ActualCPUms="1125" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="1817" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="54424" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1202" ActualCPUms="1149" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="1827" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="54424" OutputMemoryGrant="54040" UsedMemoryGrant="54424" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" /> | |
| </RunTimeInformation> | |
| <Sort Distinct="false"> | |
| <OrderBy> | |
| <OrderByColumn Ascending="true"> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </OrderByColumn> | |
| </OrderBy> | |
| <RelOp AvgRowSize="22" EstimateCPU="1.56302" EstimateIO="10.9379" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5683580" EstimatedRowsRead="5683580" LogicalOp="Index Seek" NodeId="6" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="12.501" TableCardinality="500000000"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="777700" ActualRowsRead="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="206" ActualCPUms="204" ActualScans="1" ActualLogicalReads="2050" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="777700" ActualRowsRead="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="190" ActualCPUms="189" ActualScans="1" ActualLogicalReads="2050" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="622160" ActualRowsRead="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="231" ActualCPUms="231" ActualScans="1" ActualLogicalReads="1640" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="466620" ActualRowsRead="466620" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="180" ActualCPUms="179" ActualScans="1" ActualLogicalReads="1230" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="622160" ActualRowsRead="622160" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="201" ActualCPUms="194" ActualScans="1" ActualLogicalReads="1640" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="563717" ActualRowsRead="563717" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="216" ActualCPUms="198" ActualScans="1" ActualLogicalReads="1487" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="773595" ActualRowsRead="773595" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="202" ActualCPUms="202" ActualScans="1" ActualLogicalReads="2040" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="777700" ActualRowsRead="777700" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="212" ActualCPUms="210" ActualScans="1" ActualLogicalReads="2050" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField2" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[269888]" Schema="[dbo]" Table="[Table1]" Index="[IX_Table1_1]" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField1" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="(157)"> | |
| <Const ConstValue="(157)" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| <StartRange ScanType="GE"> | |
| <RangeColumns> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="DateField1" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="'1918-02-19'"> | |
| <Const ConstValue="'1918-02-19'" /> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </StartRange> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </Sort> | |
| </RelOp> | |
| <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="5683580" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="8" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="6726.36" TableCardinality="500000000"> | |
| <OutputList> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="8" ActualRows="777700" ActualRowsRead="777700" Batches="0" ActualEndOfScans="0" ActualExecutions="777700" ActualExecutionMode="Row" ActualElapsedms="2448" ActualCPUms="2030" ActualScans="0" ActualLogicalReads="2964955" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="7" ActualRows="777700" ActualRowsRead="777700" Batches="0" ActualEndOfScans="0" ActualExecutions="777700" ActualExecutionMode="Row" ActualElapsedms="2307" ActualCPUms="2290" ActualScans="0" ActualLogicalReads="2964955" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="6" ActualRows="622160" ActualRowsRead="622160" Batches="0" ActualEndOfScans="0" ActualExecutions="622160" ActualExecutionMode="Row" ActualElapsedms="2042" ActualCPUms="2030" ActualScans="0" ActualLogicalReads="2371958" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="5" ActualRows="466620" ActualRowsRead="466620" Batches="0" ActualEndOfScans="0" ActualExecutions="466620" ActualExecutionMode="Row" ActualElapsedms="1721" ActualCPUms="1609" ActualScans="0" ActualLogicalReads="1778964" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="4" ActualRows="622160" ActualRowsRead="622160" Batches="0" ActualEndOfScans="0" ActualExecutions="622160" ActualExecutionMode="Row" ActualElapsedms="2020" ActualCPUms="2002" ActualScans="0" ActualLogicalReads="2371958" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="3" ActualRows="563717" ActualRowsRead="563717" Batches="0" ActualEndOfScans="0" ActualExecutions="563717" ActualExecutionMode="Row" ActualElapsedms="1863" ActualCPUms="1850" ActualScans="0" ActualLogicalReads="2149145" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="2" ActualRows="773595" ActualRowsRead="773595" Batches="0" ActualEndOfScans="0" ActualExecutions="773595" ActualExecutionMode="Row" ActualElapsedms="2252" ActualCPUms="2251" ActualScans="0" ActualLogicalReads="2949306" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="1" ActualRows="777700" ActualRowsRead="777700" Batches="0" ActualEndOfScans="0" ActualExecutions="777700" ActualExecutionMode="Row" ActualElapsedms="2290" ActualCPUms="2287" ActualScans="0" ActualLogicalReads="2964955" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
| </RunTimeInformation> | |
| <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField3" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="IntField4" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[269888]" Schema="[dbo]" Table="[Table1]" Index="[PK_Table1]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[269888].[dbo].[Table1].[Id]"> | |
| <Identifier> | |
| <ColumnReference Database="[269888]" Schema="[dbo]" Table="[Table1]" Column="Id" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| </Update> | |
| </RelOp> | |
| </Parallelism> | |
| </RelOp> | |
| </QueryPlan> | |
| </StmtSimple> | |
| </Statements> | |
| </Batch> | |
| </BatchSequence> | |
| </ShowPlanXML> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment