Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT COUNT(0) FROM ... Query Plan
<?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 &#xD;&#xA;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