Created
August 16, 2017 18:13
-
-
Save fuzzzerd/ca9bbdcf83d28f9d7abcdbc689d48b65 to your computer and use it in GitHub Desktop.
SELECT COUNT(0) FROM ... Query Plan
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-16"?> | |
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.6" Build="14.0.700.182" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
<BatchSequence> | |
<Batch> | |
<Statements> | |
<StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="130" StatementSubTreeCost="163.848" StatementText="SELECT count(0) FROM dbo.vProductList 
WHERE 1 = 1 AND ProductId IN (SELECT ProductId FROM ProductAdCopies WHERE AdVersion = 'Z')" StatementType="SELECT" QueryHash="0x6B2B4F52DAA15819" QueryPlanHash="0x42E0B3D129D85B81" RetrievedFromCache="true" StatementSqlHandle="0x09009AD0F132FF195D4B19C067062E7C4A200000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="4" ParentObjectId="0" StatementParameterizationType="0" SecurityPolicyApplied="false"> | |
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> | |
<QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="EstimatedDOPIsOne" MemoryGrant="135504" CachedPlanSize="320" CompileTime="1859" CompileCPU="1476" CompileMemory="19016"> | |
<MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="135504" RequiredMemory="2048" DesiredMemory="135504" RequestedMemory="135504" GrantWaitTime="0" GrantedMemory="135504" MaxUsedMemory="53192" MaxQueryMemory="1078232" /> | |
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="11744005" EstimatedPagesCached="734000" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="4180848" /> | |
<WaitStats> | |
<Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="46" WaitCount="21699" /> | |
<Wait WaitType="RESOURCE_GOVERNOR_IDLE" WaitTimeMs="49" WaitCount="11" /> | |
<Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="294" WaitCount="376061" /> | |
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="472" WaitCount="3560" /> | |
<Wait WaitType="IO_QUEUE_LIMIT" WaitTimeMs="2478" WaitCount="168" /> | |
<Wait WaitType="PAGEIOLATCH_SH" WaitTimeMs="178177" WaitCount="7187" /> | |
</WaitStats> | |
<QueryTimeStats CpuTime="24338" ElapsedTime="202878" /> | |
<RelOp AvgRowSize="11" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="163.848"> | |
<OutputList> | |
<ColumnReference Column="Expr1039" /> | |
</OutputList> | |
<ComputeScalar> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="Expr1039" /> | |
<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1044],0)"> | |
<Convert DataType="int" Style="0" Implicit="true"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="globalagg1044" /> | |
</Identifier> | |
</ScalarOperator> | |
</Convert> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="15" EstimateCPU="3.57257E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Aggregate" NodeId="2" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="163.848"> | |
<OutputList> | |
<ColumnReference Column="globalagg1044" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="202877" ActualCPUms="24338" /> | |
</RunTimeInformation> | |
<StreamAggregate> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="globalagg1044" /> | |
<ScalarOperator ScalarString="SUM([partialagg1043])"> | |
<Aggregate AggType="SUM" Distinct="false"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Column="partialagg1043" /> | |
</Identifier> | |
</ScalarOperator> | |
</Aggregate> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<RelOp AvgRowSize="15" EstimateCPU="0.000569127" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="58.7094" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="163.848"> | |
<OutputList> | |
<ColumnReference Column="partialagg1043" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366115" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="202705" ActualCPUms="24165" /> | |
</RunTimeInformation> | |
<NestedLoops Optimized="false" WithUnorderedPrefetch="true"> | |
<OuterReferences> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
<ColumnReference Column="Expr1045" /> | |
</OuterReferences> | |
<RelOp AvgRowSize="31" EstimateCPU="0.241304" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="136.155" LogicalOp="Aggregate" NodeId="5" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="163.404"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
<ColumnReference Column="partialagg1043" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366115" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="139828" ActualCPUms="17583" /> | |
</RunTimeInformation> | |
<StreamAggregate> | |
<DefinedValues> | |
<DefinedValue> | |
<ColumnReference Column="partialagg1043" /> | |
<ScalarOperator ScalarString="Count(*)"> | |
<Aggregate AggType="countstar" Distinct="false" /> | |
</ScalarOperator> | |
</DefinedValue> | |
</DefinedValues> | |
<GroupBy> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</GroupBy> | |
<RelOp AvgRowSize="39" EstimateCPU="2.1682" EstimateIO="0.039438" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="163.162"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="139519" ActualCPUms="17276" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[currency]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [currency].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[currency]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="2.17265" EstimateIO="0.057592" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="158.477"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="131873" ActualCPUms="16405" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asdir]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [asdir].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asdir]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="2.17807" EstimateIO="0.083884" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="153.768"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="126017" ActualCPUms="15666" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asnum]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [asnum].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asnum]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="2.11524" EstimateIO="0.131773" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="149.028"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="103962" ActualCPUms="14818" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asname]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [asname].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asname]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="2.03355" EstimateIO="0.192495" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="371810" LogicalOp="Inner Join" NodeId="10" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="144.303"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="72339" ActualCPUms="13838" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[state]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [state].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[state]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="1.96463" EstimateIO="0.280761" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="343093" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="139.599"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="68637" ActualCPUms="13153" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[county]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [county].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[county]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="1.91094" EstimateIO="0.409091" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="316593" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="134.875"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="67976" ActualCPUms="12518" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[country]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [country].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[country]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="1.87637" EstimateIO="0.596265" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="292140" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="130.077"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="67275" ActualCPUms="11885" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[city]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [city].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[city]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="1.86606" EstimateIO="0.868888" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="269576" LogicalOp="Inner Join" NodeId="14" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="125.127"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="66267" ActualCPUms="11258" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[zip]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [zip].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[zip]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="1.88807" EstimateIO="1.26609" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="248755" LogicalOp="Inner Join" NodeId="15" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="119.914"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="59374" ActualCPUms="10416" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[mls]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [mls].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[mls]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="1.95454" EstimateIO="1.84545" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="229541" LogicalOp="Inner Join" NodeId="16" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="114.281"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="20457" ActualCPUms="9430" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[webCode]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [webCode].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[webCode]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="2.08281" EstimateIO="2.6893" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="211812" LogicalOp="Inner Join" NodeId="17" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="108.003"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="9991" ActualCPUms="8590" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[vip]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [vip].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[vip]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="2.29896" EstimateIO="3.91939" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="195452" LogicalOp="Inner Join" NodeId="18" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="100.753"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="9047" ActualCPUms="7976" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[cls]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [cls].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[cls]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="2.64065" EstimateIO="5.71131" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="180356" LogicalOp="Inner Join" NodeId="19" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="92.0567"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366184" ActualRowsRead="9" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="7911" ActualCPUms="7308" ActualScans="2" ActualLogicalReads="23" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" /> | |
</RunTimeInformation> | |
<Merge ManyToMany="true"> | |
<InnerSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propName]" Column="ProductId" /> | |
</InnerSideJoinColumns> | |
<OuterSideJoinColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OuterSideJoinColumns> | |
<Residual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [propName].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propName]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</Residual> | |
<RelOp AvgRowSize="39" EstimateCPU="13.2495" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="166426" LogicalOp="Sort" NodeId="20" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="81.2267"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<MemoryFractions Input="0.300913" Output="1" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="366179" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="6643" ActualCPUms="6248" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="40664" OutputMemoryGrant="133584" UsedMemoryGrant="27048" /> | |
</RunTimeInformation> | |
<Sort Distinct="false"> | |
<OrderBy> | |
<OrderByColumn Ascending="true"> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</OrderByColumn> | |
</OrderBy> | |
<RelOp AvgRowSize="39" EstimateCPU="7.85379" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="166426" LogicalOp="Inner Join" NodeId="21" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="67.9659"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<MemoryFractions Input="0.280062" Output="0.699087" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366179" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="6208" ActualCPUms="5816" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="38400" OutputMemoryGrant="94320" UsedMemoryGrant="26144" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propClass]" Column="ProductId" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [propClass].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propClass]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="39" EstimateCPU="7.45152" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="153572" LogicalOp="Inner Join" NodeId="22" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="57.6341"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<MemoryFractions Input="0.257883" Output="0.719938" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366179" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5085" ActualCPUms="4767" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="35440" OutputMemoryGrant="97104" UsedMemoryGrant="26144" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[compPropType]" Column="ProductId" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [compPropType].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[compPropType]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="39" EstimateCPU="7.08031" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="141710" LogicalOp="Inner Join" NodeId="23" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="47.7045"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<MemoryFractions Input="0.237382" Output="0.742117" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366179" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4117" ActualCPUms="3812" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="32704" OutputMemoryGrant="100056" UsedMemoryGrant="25320" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[pOrigListDate]" Column="ProductId" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [pOrigListDate].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[pOrigListDate]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="39" EstimateCPU="6.7385" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="130765" LogicalOp="Inner Join" NodeId="24" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="38.1461"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<MemoryFractions Input="0.218499" Output="0.762618" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366179" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3059" ActualCPUms="2820" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="30184" OutputMemoryGrant="102800" UsedMemoryGrant="25320" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[plistDate]" Column="ProductId" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]=[devdatabase].[dbo].[Metadata].[ProductId] as [plistDate].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[plistDate]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="39" EstimateCPU="8.90912" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="120687" LogicalOp="Inner Join" NodeId="25" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="28.9295"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<MemoryFractions Input="0.431123" Output="0.781501" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366179" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1939" ActualCPUms="1787" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="58560" OutputMemoryGrant="105320" UsedMemoryGrant="21808" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Properties].[ProductId] as [p].[ProductId]=[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="23" EstimateCPU="10.9832" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="278144" LogicalOp="Right Semi Join" NodeId="26" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="17.7877"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</OutputList> | |
<MemoryFractions Input="1" Output="0.568877" /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366123" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1034" ActualCPUms="949" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="134480" OutputMemoryGrant="76944" UsedMemoryGrant="21808" /> | |
</RunTimeInformation> | |
<Hash> | |
<DefinedValues /> | |
<HashKeysBuild> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductAdCopies]" Column="ProductId" /> | |
</HashKeysBuild> | |
<HashKeysProbe> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</HashKeysProbe> | |
<ProbeResidual> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[Properties].[ProductId] as [p].[ProductId]=[devdatabase].[dbo].[ProductAdCopies].[ProductId]"> | |
<Compare CompareOp="EQ"> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductAdCopies]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
</Compare> | |
</ScalarOperator> | |
</ProbeResidual> | |
<RelOp AvgRowSize="23" EstimateCPU="0.402068" EstimateIO="4.5509" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="365374" EstimatedRowsRead="365374" LogicalOp="Index Seek" NodeId="27" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="4.95297" TableCardinality="839993"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductAdCopies]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366126" ActualRowsRead="366126" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="139" ActualCPUms="134" ActualScans="1" ActualLogicalReads="6242" 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="[devdatabase]" Schema="[dbo]" Table="[ProductAdCopies]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[ProductAdCopies]" Index="[ProductAdCopies_VersionLanguageProductId]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductAdCopies]" Column="AdVersion" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="N'Z'"> | |
<Const ConstValue="N'Z'" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442471" EstimateIO="1.40905" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402104" EstimatedRowsRead="402104" LogicalOp="Index Scan" NodeId="28" Parallel="false" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.85152" TableCardinality="402104"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402104" ActualRowsRead="402104" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="162" ActualCPUms="162" ActualScans="1" ActualLogicalReads="1917" 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="[devdatabase]" Schema="[dbo]" Table="[Properties]" Alias="[p]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Properties]" Index="[Ix_Properties_MarketMajorId]" Alias="[p]" IndexKind="NonClustered" Storage="RowStore" /> | |
</IndexScan> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
<RelOp AvgRowSize="39" EstimateCPU="0.445176" EstimateIO="1.78756" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="404563" EstimatedRowsRead="404563" LogicalOp="Index Seek" NodeId="29" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.23274" TableCardinality="1010400"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="404562" ActualRowsRead="404562" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="152" ActualCPUms="152" ActualScans="1" ActualLogicalReads="2426" 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="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Index="[IX_ProductProductStatus_CurrentAndStatusIds]" Alias="[pps]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="CurrentProductStatus" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="(1)"> | |
<Const ConstValue="(1)" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
<RelOp AvgRowSize="31" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="30" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[plistDate]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="160" ActualCPUms="159" ActualScans="1" ActualLogicalReads="3923" ActualPhysicalReads="0" ActualReadAheads="78" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[plistDate]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[plistDate]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[plistDate]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'10613D3D-891A-4EFC-B367-D7DE3BF450E3'}"> | |
<Const ConstValue="{guid'10613D3D-891A-4EFC-B367-D7DE3BF450E3'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="31" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[pOrigListDate]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="155" ActualCPUms="155" ActualScans="1" ActualLogicalReads="4329" ActualPhysicalReads="0" ActualReadAheads="145" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[pOrigListDate]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[pOrigListDate]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[pOrigListDate]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'806A4CF4-BE50-4016-A7B9-5912B4585863'}"> | |
<Const ConstValue="{guid'806A4CF4-BE50-4016-A7B9-5912B4585863'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="32" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[compPropType]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="182" ActualCPUms="182" ActualScans="1" ActualLogicalReads="3619" ActualPhysicalReads="0" ActualReadAheads="945" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[compPropType]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[compPropType]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[compPropType]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'A2027932-0D79-4A5B-B148-002FE8BB2280'}"> | |
<Const ConstValue="{guid'A2027932-0D79-4A5B-B148-002FE8BB2280'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="33" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propClass]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="160" ActualCPUms="155" ActualScans="1" ActualLogicalReads="3746" ActualPhysicalReads="0" ActualReadAheads="33" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propClass]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[propClass]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propClass]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'BECD031A-253D-40FD-AD21-0BE465879B7A'}"> | |
<Const ConstValue="{guid'BECD031A-253D-40FD-AD21-0BE465879B7A'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Hash> | |
</RelOp> | |
</Sort> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="34" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propName]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402065" ActualRowsRead="402065" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="522" ActualCPUms="313" ActualScans="1" ActualLogicalReads="4956" ActualPhysicalReads="18" ActualReadAheads="2727" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propName]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[propName]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[propName]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'FBBBE03F-5ED7-42FD-8450-9749141D4EB6'}"> | |
<Const ConstValue="{guid'FBBBE03F-5ED7-42FD-8450-9749141D4EB6'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="35" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[cls]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="701" ActualCPUms="234" ActualScans="1" ActualLogicalReads="3409" ActualPhysicalReads="50" ActualReadAheads="1161" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[cls]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[cls]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[cls]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'59F5DEC4-29AB-4E1E-A9D8-A8845DBF634B'}"> | |
<Const ConstValue="{guid'59F5DEC4-29AB-4E1E-A9D8-A8845DBF634B'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="36" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[vip]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="520" ActualCPUms="190" ActualScans="1" ActualLogicalReads="2565" ActualPhysicalReads="9" ActualReadAheads="758" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[vip]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[vip]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[vip]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'407DFFCD-73C1-4FFF-BE25-769230483DAD'}"> | |
<Const ConstValue="{guid'407DFFCD-73C1-4FFF-BE25-769230483DAD'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="37" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[webCode]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="10058" ActualCPUms="432" ActualScans="1" ActualLogicalReads="2565" ActualPhysicalReads="675" ActualReadAheads="698" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[webCode]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[webCode]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[webCode]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'57C88308-1584-478B-BE95-E51CA9288629'}"> | |
<Const ConstValue="{guid'57C88308-1584-478B-BE95-E51CA9288629'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="38" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[mls]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="38520" ActualCPUms="589" ActualScans="1" ActualLogicalReads="3337" ActualPhysicalReads="446" ActualReadAheads="1074" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[mls]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[mls]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[mls]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'71D0BC03-591C-4F70-AA3F-13A7E0041706'}"> | |
<Const ConstValue="{guid'71D0BC03-591C-4F70-AA3F-13A7E0041706'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="39" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[zip]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="6465" ActualCPUms="414" ActualScans="1" ActualLogicalReads="3447" ActualPhysicalReads="739" ActualReadAheads="1377" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[zip]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[zip]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[zip]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'8EBBA47C-C1A4-4FCC-A0EC-AF722B68BCB1'}"> | |
<Const ConstValue="{guid'8EBBA47C-C1A4-4FCC-A0EC-AF722B68BCB1'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="40" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[city]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="597" ActualCPUms="216" ActualScans="1" ActualLogicalReads="3520" ActualPhysicalReads="38" ActualReadAheads="1027" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[city]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[city]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[city]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'0AA2F584-620E-4CFD-A12A-AF0C0DB266BC'}"> | |
<Const ConstValue="{guid'0AA2F584-620E-4CFD-A12A-AF0C0DB266BC'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="41" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[country]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="264" ActualCPUms="196" ActualScans="1" ActualLogicalReads="3193" ActualPhysicalReads="10" ActualReadAheads="1722" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[country]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[country]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[country]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'C9C8ED3C-511E-4EB9-85EE-8C994B946A02'}"> | |
<Const ConstValue="{guid'C9C8ED3C-511E-4EB9-85EE-8C994B946A02'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="42" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[county]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="235" ActualCPUms="209" ActualScans="1" ActualLogicalReads="3111" ActualPhysicalReads="2" ActualReadAheads="11" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[county]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[county]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[county]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'9AE7A5D5-5A3D-41B3-838F-C63AECA2819B'}"> | |
<Const ConstValue="{guid'9AE7A5D5-5A3D-41B3-838F-C63AECA2819B'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="43" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[state]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3254" ActualCPUms="238" ActualScans="1" ActualLogicalReads="2884" ActualPhysicalReads="77" ActualReadAheads="1288" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[state]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[state]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[state]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'1C66A911-E1FE-487F-8662-525BBC2C3A54'}"> | |
<Const ConstValue="{guid'1C66A911-E1FE-487F-8662-525BBC2C3A54'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="44" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asname]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="31244" ActualCPUms="600" ActualScans="1" ActualLogicalReads="3922" ActualPhysicalReads="539" ActualReadAheads="1415" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asname]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[asname]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asname]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'2326C5C2-D937-43F3-9F44-2F0751F42CDC'}"> | |
<Const ConstValue="{guid'2326C5C2-D937-43F3-9F44-2F0751F42CDC'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="45" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asnum]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="21646" ActualCPUms="440" ActualScans="1" ActualLogicalReads="2700" ActualPhysicalReads="356" ActualReadAheads="730" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asnum]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[asnum]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asnum]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'14B96459-7B53-4F39-AFAE-06BE5B78B679'}"> | |
<Const ConstValue="{guid'14B96459-7B53-4F39-AFAE-06BE5B78B679'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="46" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asdir]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5461" ActualCPUms="344" ActualScans="1" ActualLogicalReads="2489" ActualPhysicalReads="598" ActualReadAheads="783" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asdir]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[asdir]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[asdir]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'0BCF4B24-B7DE-48A9-A5A2-DF0B03624D2A'}"> | |
<Const ConstValue="{guid'0BCF4B24-B7DE-48A9-A5A2-DF0B03624D2A'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
<RelOp AvgRowSize="23" EstimateCPU="0.442423" EstimateIO="2.03565" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" EstimatedRowsRead="402060" LogicalOp="Index Seek" NodeId="47" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.47807" TableCardinality="88803300"> | |
<OutputList> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[currency]" Column="ProductId" /> | |
</OutputList> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="7163" ActualCPUms="388" ActualScans="1" ActualLogicalReads="3616" ActualPhysicalReads="909" ActualReadAheads="1215" 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="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[currency]" Column="ProductId" /> | |
</DefinedValue> | |
</DefinedValues> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[currency]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[currency]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="{guid'623E7AC7-0A4D-4CCD-9016-F04792BF1D88'}"> | |
<Const ConstValue="{guid'623E7AC7-0A4D-4CCD-9016-F04792BF1D88'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</Merge> | |
</RelOp> | |
</StreamAggregate> | |
</RelOp> | |
<RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="135.155" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Index Seek" NodeId="48" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.443829" TableCardinality="88803300"> | |
<OutputList /> | |
<RunTimeInformation> | |
<RunTimeCountersPerThread Thread="0" ActualRows="366115" ActualRowsRead="366115" Batches="0" ActualEndOfScans="366115" ActualExecutions="366115" ActualExecutionMode="Row" ActualElapsedms="21973" ActualCPUms="3544" ActualScans="366115" ActualLogicalReads="1468603" ActualPhysicalReads="2398" 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 /> | |
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_ProductId]" Alias="[price]" IndexKind="NonClustered" Storage="RowStore" /> | |
<SeekPredicates> | |
<SeekPredicateNew> | |
<SeekKeys> | |
<Prefix ScanType="EQ"> | |
<RangeColumns> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[price]" Column="ProductId" /> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[price]" Column="FieldNameId" /> | |
</RangeColumns> | |
<RangeExpressions> | |
<ScalarOperator ScalarString="[devdatabase].[dbo].[ProductProductStatus].[ProductId] as [pps].[ProductId]"> | |
<Identifier> | |
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductProductStatus]" Alias="[pps]" Column="ProductId" /> | |
</Identifier> | |
</ScalarOperator> | |
<ScalarOperator ScalarString="{guid'A4FB29A2-0620-4C15-809C-BB843AB8E7F4'}"> | |
<Const ConstValue="{guid'A4FB29A2-0620-4C15-809C-BB843AB8E7F4'}" /> | |
</ScalarOperator> | |
</RangeExpressions> | |
</Prefix> | |
</SeekKeys> | |
</SeekPredicateNew> | |
</SeekPredicates> | |
</IndexScan> | |
</RelOp> | |
</NestedLoops> | |
</RelOp> | |
</StreamAggregate> | |
</RelOp> | |
</ComputeScalar> | |
</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