Created
July 14, 2019 13:48
-
-
Save erikdarlingdata/62a978d2dcb94d6b35c1d5a56609bac4 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="585.313" 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 DESC
 )
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="0xCA4B1AB3E02DED0C" QueryPlanHash="0xA1A7D17E4ADBDE0B" 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="291232" CachedPlanSize="96" CompileTime="7" CompileCPU="7" CompileMemory="744"> | |
<ThreadStat Branches="4" UsedThreads="13"> | |
<ThreadReservation NodeId="0" ReservedThreads="16" /> | |
</ThreadStat> | |
<MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="281720" RequiredMemory="11040" DesiredMemory="291232" RequestedMemory="291232" GrantWaitTime="0" GrantedMemory="291232" MaxUsedMemory="178272" MaxQueryMemory="9702144" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="655360" EstimatedPagesCached="327680" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="37921512" /> | |
<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="MEMORY_ALLOCATION_EXT" WaitTimeMs="2" WaitCount="2420" /> | |
<Wait WaitType="PAGEIOLATCH_SH" WaitTimeMs="4" WaitCount="2" /> | |
<Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="24" WaitCount="24663" /> | |
<Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="31" WaitCount="1" /> | |
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="231" WaitCount="282" /> | |
<Wait WaitType="CXPACKET" WaitTimeMs="42925" WaitCount="6846" /> | |
</WaitStats> | |
<QueryTimeStats CpuTime="19191" ElapsedTime="13742" /> | |
<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="585.313"> | |
<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="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="13700" ActualCPUms="5" /> | |
</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="426.246"> | |
<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="12995" ActualCPUms="2347" 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="12995" ActualCPUms="1638" 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="12996" ActualCPUms="2363" 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="12995" ActualCPUms="1636" 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="699" 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> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="617129" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="12081" ActualCPUms="2010" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="616255" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="12111" ActualCPUms="1334" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="616122" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="12080" ActualCPUms="2023" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="616038" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="12108" ActualCPUms="1344" /> | |
<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="613836" ActualRowsRead="613836" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="446" ActualCPUms="445" ActualScans="1" ActualLogicalReads="11126" ActualPhysicalReads="0" ActualReadAheads="373" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="665516" ActualRowsRead="665516" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="478" ActualCPUms="477" ActualScans="1" ActualLogicalReads="11893" ActualPhysicalReads="0" ActualReadAheads="658" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="594442" ActualRowsRead="594442" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="406" ActualCPUms="404" ActualScans="1" ActualLogicalReads="10647" ActualPhysicalReads="0" ActualReadAheads="653" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="591878" ActualRowsRead="591878" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="413" ActualCPUms="410" ActualScans="1" ActualLogicalReads="10997" ActualPhysicalReads="0" ActualReadAheads="569" 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="45.0125" EstimateIO="0.00281532" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Sort" NodeId="4" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="182.624"> | |
<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> | |
<MemoryFractions Input="0.5" Output="0.485053" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="383176" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="766" ActualCPUms="189" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="35536" OutputMemoryGrant="34104" UsedMemoryGrant="21864" /> | |
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="380298" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="764" ActualCPUms="184" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="35536" OutputMemoryGrant="34104" UsedMemoryGrant="21696" /> | |
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="383872" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="769" ActualCPUms="192" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="35536" OutputMemoryGrant="34104" UsedMemoryGrant="21896" /> | |
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="383961" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="766" ActualCPUms="171" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="35536" OutputMemoryGrant="34104" UsedMemoryGrant="21912" /> | |
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="699" 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="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="19" EstimateCPU="7.39485" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Distribute Streams" NodeId="5" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="137.608"> | |
<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="595" ActualCPUms="18" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="380298" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="597" ActualCPUms="18" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="383872" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="593" ActualCPUms="16" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="383961" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="609" ActualCPUms="13" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="699" 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="6" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="130.214"> | |
<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="486" ActualCPUms="283" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="699" 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="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="130.025"> | |
<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="409" ActualCPUms="205" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="699" ActualCPUms="0" /> | |
</RunTimeInformation> | |
<Parallelism> | |
<OrderBy> | |
<OrderByColumn Ascending="false"> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="19" EstimateCPU="45.0125" EstimateIO="0.00281532" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="TopN Sort" NodeId="8" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="118.992"> | |
<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> | |
<MemoryFractions Input="0.485053" Output="0.5" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="383176" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="746" ActualCPUms="284" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="34488" OutputMemoryGrant="35152" UsedMemoryGrant="21864" /> | |
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="380298" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="746" ActualCPUms="287" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="34488" OutputMemoryGrant="35152" UsedMemoryGrant="21696" /> | |
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="383872" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="747" ActualCPUms="285" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="34488" OutputMemoryGrant="35152" UsedMemoryGrant="21896" /> | |
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="383961" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="742" ActualCPUms="292" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="34488" OutputMemoryGrant="35152" UsedMemoryGrant="21912" /> | |
<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> | |
<TopSort Distinct="false" Rows="2147483647"> | |
<OrderBy> | |
<OrderByColumn Ascending="false"> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="19" EstimateCPU="13.769" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1881930" LogicalOp="Inner Join" NodeId="9" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="73.9763"> | |
<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> | |
<MemoryFractions Input="1" Output="0.514947" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="4" ActualRows="383176" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="588" ActualCPUms="126" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="71072" OutputMemoryGrant="37088" UsedMemoryGrant="3904" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="380298" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="585" ActualCPUms="127" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="71072" OutputMemoryGrant="37088" UsedMemoryGrant="3904" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="383872" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="585" ActualCPUms="124" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="71072" OutputMemoryGrant="37088" UsedMemoryGrant="3904" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="383961" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="579" ActualCPUms="129" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="71072" OutputMemoryGrant="37088" UsedMemoryGrant="3912" /> | |
<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" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<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> | |
</ProbeResidual> | |
<RelOp AvgRowSize="11" EstimateCPU="0.288106" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="433354" LogicalOp="Bitmap Create" NodeId="10" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="6.4755"> | |
<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="65" ActualCPUms="14" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="512" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="66480" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="56" ActualCPUms="14" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="512" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="66334" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="75" ActualCPUms="13" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="512" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="66927" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="60" ActualCPUms="14" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="512" /> | |
<RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" /> | |
</RunTimeInformation> | |
<Bitmap> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Bitmap1003" /> | |
</DefinedValue> | |
</DefinedValues> | |
<HashKeys> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Users]" Alias="[u]" Column="Id" /> | |
</HashKeys> | |
<RelOp AvgRowSize="11" EstimateCPU="0.288106" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="433354" LogicalOp="Repartition Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="6.4755"> | |
<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="54" ActualCPUms="3" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="66480" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="44" ActualCPUms="3" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="66334" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="65" ActualCPUms="3" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="66927" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="49" ActualCPUms="3" /> | |
<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="23" EstimateCPU="0.67811" EstimateIO="4.96683" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="433354" EstimatedRowsRead="2465710" LogicalOp="Index Scan" NodeId="12" 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="60318" ActualRowsRead="594320" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="86" ActualCPUms="55" ActualScans="1" ActualLogicalReads="1640" ActualPhysicalReads="0" ActualReadAheads="6" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="73577" ActualRowsRead="615475" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="100" ActualCPUms="60" ActualScans="1" ActualLogicalReads="1703" ActualPhysicalReads="0" ActualReadAheads="6" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="83291" ActualRowsRead="735737" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="100" ActualCPUms="62" ActualScans="1" ActualLogicalReads="2035" ActualPhysicalReads="0" ActualReadAheads="6" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="49359" ActualRowsRead="520181" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="95" ActualCPUms="58" ActualScans="1" ActualLogicalReads="1442" ActualPhysicalReads="0" ActualReadAheads="1" 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="false" 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> | |
</Bitmap> | |
</RelOp> | |
<RelOp AvgRowSize="19" EstimateCPU="6.12706" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6232160" LogicalOp="Repartition Streams" NodeId="13" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="53.7317"> | |
<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="386021" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="411" ActualCPUms="17" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="383063" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="407" ActualCPUms="17" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="388846" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="409" ActualCPUms="18" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="386847" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="402" ActualCPUms="19" /> | |
<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> | |
<RelOp AvgRowSize="23" EstimateCPU="4.71414" EstimateIO="40.8335" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="6232160" EstimatedRowsRead="17142200" LogicalOp="Index Scan" NodeId="14" 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="386932" ActualRowsRead="4195484" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="328" ActualCPUms="327" ActualScans="1" ActualLogicalReads="13661" ActualPhysicalReads="0" ActualReadAheads="6" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="3" ActualRows="409156" ActualRowsRead="4271896" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="342" ActualCPUms="337" ActualScans="1" ActualLogicalReads="13906" ActualPhysicalReads="0" ActualReadAheads="4" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="2" ActualRows="393054" ActualRowsRead="4388727" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="324" ActualCPUms="323" ActualScans="1" ActualLogicalReads="14287" ActualPhysicalReads="0" ActualReadAheads="10" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
<RunTimeCountersPerThread Thread="1" ActualRows="355635" ActualRowsRead="4286062" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="314" ActualCPUms="314" ActualScans="1" ActualLogicalReads="13961" 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="false" 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) AND PROBE([Bitmap1003],[StackOverflow2013].[dbo].[Posts].[OwnerUserId] as [p].[OwnerUserId],N'[IN ROW]')"> | |
<Logical Operation="AND"> | |
<ScalarOperator> | |
<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> | |
<ScalarOperator> | |
<Intrinsic FunctionName="PROBE"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="Bitmap1003" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[StackOverflow2013]" Schema="[dbo]" Table="[Posts]" Alias="[p]" Column="OwnerUserId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Const ConstValue="N'[IN ROW]'" /> | |
</ScalarOperator> | |
</Intrinsic> | |
</ScalarOperator> | |
</Logical> | |
</ScalarOperator> | |
</Predicate> | |
</IndexScan> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
</TopSort> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Top> | |
</RelOp> | |
</Parallelism> | |
</RelOp> | |
</Sort> | |
</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