Created
July 14, 2019 13:42
-
-
Save erikdarlingdata/d3cb9b88a2ba9f6b605e995d68e4b9a2 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:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.481" Build="14.0.3192.2" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
<BatchSequence> | |
<Batch> | |
<Statements> | |
<StmtSimple StatementCompId="1" StatementEstRows="1881930" StatementId="2" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="130" StatementSubTreeCost="518.388" StatementText="WITH precheck AS (
 SELECT TOP (2147483647) 
 u.Id, 
 p.Id AS PostId,
 p.AcceptedAnswerId
 FROM dbo.Users AS u
 JOIN dbo.Posts AS p
 ON p.OwnerUserId = u.Id
 WHERE u.CreationDate > '20110901' 
 AND u.Reputation > 100 
 AND p.PostTypeId = 1
 ORDER BY u.Id 
 )
SELECT u.*, p.*
FROM precheck p
JOIN dbo.Users AS u
 ON p.Id = u.Id
WHERE ISNULL(u.Age, p.AcceptedAnswerId) < 0
ORDER BY u.Id, u.Reputation
OPTION(USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'), RECOMPILE)" StatementType="SELECT" QueryHash="0xA907F9033E3B27E2" QueryPlanHash="0xDFEC81D0F45ABB8D" RetrievedFromCache="false" 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="4" MemoryGrant="7424" CachedPlanSize="72" CompileTime="5" CompileCPU="5" CompileMemory="728"> | |
<ThreadStat Branches="6" UsedThreads="21"> | |
<ThreadReservation NodeId="0" ReservedThreads="24" /> | |
</ThreadStat> | |
<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" RequiredMemory="7424" DesiredMemory="7424" RequestedMemory="7424" GrantWaitTime="0" GrantedMemory="7424" MaxUsedMemory="7424" MaxQueryMemory="9702144" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="655360" EstimatedPagesCached="327680" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="37921688" /> | |
<OptimizerStatsUsage> | |
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Statistics="[_WA_Sys_0000000A_08EA5793]" ModificationCount="0" SamplingPercent="5.13409" LastUpdate="2019-07-14T08:40:59.55" /> | |
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Statistics="[PK_Users_Id]" ModificationCount="0" SamplingPercent="100" LastUpdate="2019-07-04T21:32:29.75" /> | |
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[_WA_Sys_00000010_0519C6AF]" ModificationCount="0" SamplingPercent="0.879906" LastUpdate="2019-07-14T08:40:59.7" /> | |
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Statistics="[_WA_Sys_00000004_08EA5793]" ModificationCount="0" SamplingPercent="5.13409" LastUpdate="2019-07-14T08:40:59.43" /> | |
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[_WA_Sys_00000002_0519C6AF]" ModificationCount="0" SamplingPercent="0.879906" LastUpdate="2019-07-14T08:40:59.83" /> | |
<StatisticsInfo Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Statistics="[ix_posts]" ModificationCount="0" SamplingPercent="100" LastUpdate="2019-07-14T08:40:27.07" /> | |
</OptimizerStatsUsage> | |
<WaitStats> | |
<Wait WaitType="PAGELATCH_UP" WaitTimeMs="3" WaitCount="50" /> | |
<Wait WaitType="PAGELATCH_EX" WaitTimeMs="17" WaitCount="505" /> | |
<Wait WaitType="PAGEIOLATCH_SH" WaitTimeMs="43" WaitCount="22" /> | |
<Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="50" WaitCount="1" /> | |
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="552" WaitCount="50" /> | |
<Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="871" WaitCount="1148085" /> | |
<Wait WaitType="PAGEIOLATCH_EX" WaitTimeMs="40801" WaitCount="347915" /> | |
<Wait WaitType="CXPACKET" WaitTimeMs="2238553" WaitCount="14203" /> | |
</WaitStats> | |
<QueryTimeStats CpuTime="172222" ElapsedTime="225870" /> | |
<RelOp AvgRowSize="4481" EstimateCPU="159.066" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="518.388"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AboutMe" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Age" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="CreationDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DisplayName" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DownVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="EmailHash" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="LastAccessDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Location" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Reputation" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="UpVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Views" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="WebsiteUrl" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AccountId" /> | |
</OutputList> | |
<Warnings> | |
<SpillToTempDb SpillLevel="0" SpilledThreadCount="1" /> | |
<ExchangeSpillDetails WritesToTempDb="4" /> | |
</Warnings> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="225819" ActualCPUms="1" /> | |
</RunTimeInformation> | |
<Parallelism> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="4481" EstimateCPU="2.80144" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Inner Join" NodeId="1" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="359.322"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AboutMe" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Age" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="CreationDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DisplayName" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DownVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="EmailHash" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="LastAccessDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Location" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Reputation" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="UpVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Views" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="WebsiteUrl" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AccountId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="130102" ActualCPUms="2864" 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="110207" ActualCPUms="7962" 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="83637" ActualCPUms="2795" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="42408" ActualCPUms="2675" 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> | |
<Merge ManyToMany="false"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Users].[Id] as [u].[Id]=[StackOverflow2013].[dbo].[Users].[Id] as [u].[Id] AND isnull([StackOverflow2013].[dbo].[Users].[Age] as [u].[Age],[StackOverflow2013].[dbo].[Posts].[AcceptedAnswerId] as [p].[AcceptedAnswerId])<(0)"> | |
<Logical Operation="AND"> | |
<ScalarOperator> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Compare CompareOp="LT"> | |
<ScalarOperator> | |
<Intrinsic FunctionName="isnull"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Age" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(0)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Logical> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="4468" EstimateCPU="207.277" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2465710" LogicalOp="Repartition Streams" NodeId="2" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="240.821"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AboutMe" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Age" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="CreationDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DisplayName" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DownVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="EmailHash" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="LastAccessDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Location" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Reputation" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="UpVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Views" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="WebsiteUrl" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AccountId" /> | |
</OutputList> | |
<Warnings> | |
<SpillToTempDb SpillLevel="0" SpilledThreadCount="4" /> | |
<ExchangeSpillDetails WritesToTempDb="5786565" /> | |
</Warnings> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="617129" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="115138" ActualCPUms="2628" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="616254" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="108027" ActualCPUms="7353" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="616122" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="81653" ActualCPUms="2566" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="616038" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="40827" ActualCPUms="2456" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</PartitionColumns> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="4468" EstimateCPU="0.67811" EstimateIO="32.8661" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2465710" EstimatedRowsRead="2465710" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="33.5442" TableCardinality="2465710"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AboutMe" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Age" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="CreationDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DisplayName" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DownVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="EmailHash" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="LastAccessDate" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Location" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Reputation" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="UpVotes" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Views" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="WebsiteUrl" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AccountId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="592425" ActualRowsRead="592425" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="737" ActualCPUms="725" ActualScans="1" ActualLogicalReads="10651" ActualPhysicalReads="0" ActualReadAheads="10573" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="606618" ActualRowsRead="606618" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="708" ActualCPUms="698" ActualScans="1" ActualLogicalReads="10950" ActualPhysicalReads="0" ActualReadAheads="10869" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="654201" ActualRowsRead="654201" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="807" ActualCPUms="796" ActualScans="1" ActualLogicalReads="11809" ActualPhysicalReads="0" ActualReadAheads="11136" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="612469" ActualRowsRead="612469" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="750" ActualCPUms="723" ActualScans="1" ActualLogicalReads="11278" ActualPhysicalReads="0" ActualReadAheads="10113" 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="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AboutMe" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Age" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="CreationDate" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DisplayName" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="DownVotes" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="EmailHash" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="LastAccessDate" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Location" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Reputation" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="UpVotes" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Views" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="WebsiteUrl" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="AccountId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Index="[PK_Users_Id]" Alias="[u]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" /> | |
</IndexScan> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
<RelOp AvgRowSize="19" EstimateCPU="7.39485" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Distribute Streams" NodeId="4" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="115.699"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
</OutputList> | |
<Warnings> | |
<SpillToTempDb SpillLevel="0" SpilledThreadCount="1" /> | |
<ExchangeSpillDetails WritesToTempDb="8890" /> | |
</Warnings> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="383176" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="14755" ActualCPUms="27" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="380298" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1597" ActualCPUms="27" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="383872" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1784" ActualCPUms="28" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="383961" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1384" ActualCPUms="22" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</PartitionColumns> | |
<RelOp AvgRowSize="19" EstimateCPU="0.188193" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Top" NodeId="5" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="108.305"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="1531307" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1816" ActualCPUms="299" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
</RunTimeInformation> | |
<Top RowCount="false" IsPercent="false" WithTies="false"> | |
<TopExpression> | |
<ScalarOperator ScalarString="(2147483647)"> | |
<Const ConstValue="(2147483647)" /> | |
</ScalarOperator> | |
</TopExpression> | |
<RelOp AvgRowSize="19" EstimateCPU="11.0338" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Gather Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="108.116"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="1" ActualRows="1531307" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1735" ActualCPUms="217" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
</RunTimeInformation> | |
<Parallelism> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="19" EstimateCPU="3.54784" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Inner Join" NodeId="7" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="97.0827"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="383176" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1701" ActualCPUms="296" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="380298" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1437" ActualCPUms="308" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="383872" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1472" ActualCPUms="307" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="383961" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1484" ActualCPUms="322" 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> | |
<Merge ManyToMany="false"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Users].[Id] as [u].[Id]=[StackOverflow2013].[dbo].[Posts].[OwnerUserId] as [p].[OwnerUserId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="11" EstimateCPU="2.45488" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="433354" LogicalOp="Repartition Streams" NodeId="8" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="8.64227"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="66804" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="31" ActualCPUms="10" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="66480" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="22" ActualCPUms="11" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="66334" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="18" ActualCPUms="11" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="66927" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="17" ActualCPUms="11" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</PartitionColumns> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="23" EstimateCPU="0.67811" EstimateIO="4.96683" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="433354" EstimatedRowsRead="2465710" LogicalOp="Index Scan" NodeId="9" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="5.64494" TableCardinality="2465710"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="80191" ActualRowsRead="735256" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="51" ActualCPUms="51" ActualScans="1" ActualLogicalReads="2033" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="64995" ActualRowsRead="638028" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="44" ActualCPUms="44" ActualScans="1" ActualLogicalReads="1766" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="49947" ActualRowsRead="475456" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="37" ActualCPUms="37" ActualScans="1" ActualLogicalReads="1312" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="71412" ActualRowsRead="616973" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="48" ActualCPUms="48" ActualScans="1" ActualLogicalReads="1705" 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="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Index="[ix_users]" Alias="[u]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" /> | |
<Predicate> | |
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Users].[CreationDate] as [u].[CreationDate]>'2011-09-01 00:00:00.000' AND [StackOverflow2013].[dbo].[Users].[Reputation] as [u].[Reputation]>(100)"> | |
<Logical Operation="AND"> | |
<ScalarOperator> | |
<Compare CompareOp="GT"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="CreationDate" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="'2011-09-01 00:00:00.000'" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Compare CompareOp="GT"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Reputation" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(100)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Logical> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
<RelOp AvgRowSize="19" EstimateCPU="37.2878" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6232160" LogicalOp="Repartition Streams" NodeId="10" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="84.8925"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="1470613" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1566" ActualCPUms="182" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="1457558" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1307" ActualCPUms="189" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="1480693" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1344" ActualCPUms="187" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="1591293" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1355" ActualCPUms="200" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" /> | |
</RunTimeInformation> | |
<Parallelism PartitioningType="Hash"> | |
<PartitionColumns> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</PartitionColumns> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="23" EstimateCPU="4.71414" EstimateIO="40.8335" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6232160" EstimatedRowsRead="17142200" LogicalOp="Index Scan" NodeId="11" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="45.5476" TableCardinality="17142200"> | |
<OutputList> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="1520111" ActualRowsRead="4523184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="364" ActualCPUms="364" ActualScans="1" ActualLogicalReads="14664" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="1012841" ActualRowsRead="3067897" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="255" ActualCPUms="255" ActualScans="1" ActualLogicalReads="9978" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="1743737" ActualRowsRead="4902259" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="413" ActualCPUms="413" ActualScans="1" ActualLogicalReads="15892" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="1723534" ActualRowsRead="4648829" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="401" ActualCPUms="401" ActualScans="1" ActualLogicalReads="15073" 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="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="Id" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="AcceptedAnswerId" /> | |
</DefinedValue> | |
<DefinedValue> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Index="[ix_posts]" Alias="[p]" IndexKind="NonClustered" Storage="RowStore" /> | |
<Predicate> | |
<ScalarOperator ScalarString="[StackOverflow2013].[dbo].[Posts].[PostTypeId] as [p].[PostTypeId]=(1)"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="PostTypeId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Top> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Merge> | |
</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