Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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.520" Build="15.0.400.390" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="5" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="130" StatementSubTreeCost="5.31137" StatementText="SELECT TOP 5
 adsSum.PartnerId as PartnerId,
 adsSum.ClientId as ClientId,
 adsSum.AdsPictureId as AdsPictureId,
 adsSum.ImageName as ImageName,
 count(*) as TotalDisplay
FROM [dbo].[TopAdsDisplaySumaryView] adsSum
GROUP BY adsSum.PartnerId,adsSum.ClientId,adsSum.AdsPictureId,adsSum.ImageName
ORDER BY TotalDisplay DESC" StatementType="SELECT" QueryHash="0x4CB303F42201C510" QueryPlanHash="0xD10A7CFE493F06AA" RetrievedFromCache="true" StatementSqlHandle="0x09004E742E2E138F3F5CCF8D6DEAC43E3A260000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="8" ParentObjectId="0" StatementParameterizationType="0" 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="0" NonParallelPlanReason="MaxDOPSetToOne" MemoryGrant="5168" CachedPlanSize="88" CompileTime="38" CompileCPU="25" CompileMemory="1440">
- <MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="5168" RequiredMemory="2048" DesiredMemory="5168" RequestedMemory="5168" GrantWaitTime="0" GrantedMemory="5168" MaxUsedMemory="960" MaxQueryMemory="244840" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="17616030" EstimatedPagesCached="1101001" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="698312" />
- <WaitStats>
- <Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="66883" WaitCount="1649" />
- <Wait WaitType="RESOURCE_GOVERNOR_IDLE" WaitTimeMs="56086" WaitCount="3980" />
- </WaitStats>
- <QueryTimeStats CpuTime="6665" ElapsedTime="73522" />
- <RelOp AvgRowSize="4051" EstimateCPU="0.000203891" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5" EstimateRowsWithoutRowGoal="16" LogicalOp="TopN Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="5.31137">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <MemoryFractions Input="0.030303" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="5" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="73521" ActualCPUms="6664" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="144" OutputMemoryGrant="144" UsedMemoryGrant="56" />
- </RunTimeInformation>
- <TopSort Distinct="false" Rows="5">
- <OrderBy>
- <OrderByColumn Ascending="false">
- <ColumnReference Column="Expr1005" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="4051" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="16" EstimateRowsWithoutRowGoal="16" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="5.29991">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1009],0)">
- <Convert DataType="int" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1009" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4051" EstimateCPU="1.75585" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="16" EstimateRowsWithoutRowGoal="16" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="5.29991">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- <ColumnReference Column="Expr1009" />
- </OutputList>
- <MemoryFractions Input="0.0820513" Output="0.969697" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="38" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="73521" ActualCPUms="6664" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="1280" OutputMemoryGrant="4048" UsedMemoryGrant="320" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1009" />
- <ScalarOperator ScalarString="COUNT(*)">
- <Aggregate AggType="COUNT*" Distinct="false" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- <ScalarOperator ScalarString="ANY([vas-db].[dbo].[Clients].[PartnerId] as [client].[PartnerId])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- <ScalarOperator ScalarString="ANY([vas-db].[dbo].[AdsPictures].[ImageName] as [adsPict].[ImageName])">
- <Aggregate AggType="ANY" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <HashKeysBuild>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- </HashKeysBuild>
- <BuildResidual>
- <ScalarOperator ScalarString="[vas-db].[dbo].[Clients].[Id] as [client].[Id] = [vas-db].[dbo].[Clients].[Id] as [client].[Id] AND [vas-db].[dbo].[AdsPictures].[Id] as [adsPict].[Id] = [vas-db].[dbo].[AdsPictures].[Id] as [adsPict].[Id]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </BuildResidual>
- <RelOp AvgRowSize="4047" EstimateCPU="1.47764" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="253819" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="3.54406">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- </OutputList>
- <MemoryFractions Input="1" Output="0.917949" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="254009" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="818" ActualCPUms="433" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="4144" OutputMemoryGrant="3888" UsedMemoryGrant="640" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[DisplyadAds]" Alias="[displayAds]" Column="AdsPictureId" />
- </HashKeysProbe>
- <RelOp AvgRowSize="4039" EstimateCPU="0.0002175" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="55" EstimatedRowsRead="55" LogicalOp="Index Scan" NodeId="4" Parallel="false" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0033425" TableCardinality="55">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="55" ActualRowsRead="55" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" 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="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Alias="[adsPict]" Column="ImageName" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[vas-db]" Schema="[dbo]" Table="[AdsPictures]" Index="[IX_AdsPictures_IncludeImageName]" Alias="[adsPict]" IndexKind="NonClustered" Storage="RowStore" />
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="19" EstimateCPU="1.06096" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="253819" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2.06307">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[DisplyadAds]" Alias="[displayAds]" Column="AdsPictureId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="254009" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="528" ActualCPUms="271" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="Id" />
- </OuterReferences>
- <RelOp AvgRowSize="19" EstimateCPU="3.344E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0121373">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="43" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[MachineGroups]" Alias="[machineGroups]" Column="ClientId" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="3.344E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00771404">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[MachineGroups]" Alias="[machineGroups]" Column="ClientId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="42" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="MachineGroupId" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="0.0001658" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="8" EstimatedRowsRead="8" LogicalOp="Clustered Index Scan" NodeId="8" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032908" TableCardinality="8">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="MachineGroupId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="8" ActualRowsRead="8" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="MachineGroupId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Index="[PK_dbo.Machines]" Alias="[machine]" IndexKind="Clustered" Storage="RowStore" />
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="7" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Clustered Index Seek" NodeId="9" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0043898" TableCardinality="6">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[MachineGroups]" Alias="[machineGroups]" Column="ClientId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="8" ActualRowsRead="8" Batches="0" ActualEndOfScans="0" ActualExecutions="8" ActualExecutionMode="Row" ActualElapsedms="42" ActualCPUms="0" ActualScans="0" ActualLogicalReads="16" 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="[vas-db]" Schema="[dbo]" Table="[MachineGroups]" Alias="[machineGroups]" Column="ClientId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[vas-db]" Schema="[dbo]" Table="[MachineGroups]" Index="[PK_dbo.MachineGroups]" Alias="[machineGroups]" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[MachineGroups]" Alias="[machineGroups]" Column="Id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[vas-db].[dbo].[Machines].[MachineGroupId] as [machine].[MachineGroupId]">
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="MachineGroupId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="7" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Clustered Index Seek" NodeId="10" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0043898" TableCardinality="9">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="8" ActualRowsRead="8" Batches="0" ActualEndOfScans="0" ActualExecutions="8" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="16" 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="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="PartnerId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Index="[PK_dbo.Clients]" Alias="[client]" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Clients]" Alias="[client]" Column="Id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[vas-db].[dbo].[MachineGroups].[ClientId] as [machineGroups].[ClientId]">
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[MachineGroups]" Alias="[machineGroups]" Column="ClientId" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0350571" EstimateIO="0.101644" EstimateRebinds="7" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="31727.4" EstimatedRowsRead="31727.4" LogicalOp="Index Seek" NodeId="11" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.989973" TableCardinality="253819">
- <OutputList>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[DisplyadAds]" Alias="[displayAds]" Column="AdsPictureId" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="254009" ActualRowsRead="254009" Batches="0" ActualEndOfScans="8" ActualExecutions="8" ActualExecutionMode="Row" ActualElapsedms="188" ActualCPUms="188" ActualScans="8" ActualLogicalReads="1107" 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="[vas-db]" Schema="[dbo]" Table="[DisplyadAds]" Alias="[displayAds]" Column="AdsPictureId" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[vas-db]" Schema="[dbo]" Table="[DisplyadAds]" Index="[MachineIdIndexIncludeAdsPictureIdDisplayFromDisplayTo]" Alias="[displayAds]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[DisplyadAds]" Alias="[displayAds]" Column="MachineId" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[vas-db].[dbo].[Machines].[Id] as [machine].[Id]">
- <Identifier>
- <ColumnReference Database="[vas-db]" Schema="[dbo]" Table="[Machines]" Alias="[machine]" Column="Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Hash>
- </RelOp>
- </Hash>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </TopSort>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement