Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT 1 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="402060" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="130" StatementSubTreeCost="167.875" StatementText="SELECT 1 FROM dbo.vProductList WHERE 1 = 1 AND ProductId IN (SELECT ProductId FROM ProductCopies WHERE Version = 'Z')" StatementType="SELECT" QueryHash="0x8EF4C8CF5509DE9E" QueryPlanHash="0xFEF318CDA58A6C49" RetrievedFromCache="true" StatementSqlHandle="0x090014092C661D199CFD896B1AD05AF0BBCC0000000000000000000000000000000000000000000000000000" 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="312" CompileTime="1886" CompileCPU="1723" CompileMemory="18256">
<MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="135504" RequiredMemory="2048" DesiredMemory="135504" RequestedMemory="135504" GrantWaitTime="0" GrantedMemory="135504" MaxUsedMemory="53192" MaxQueryMemory="1078240" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="11744005" EstimatedPagesCached="734000" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="4164400" />
<WaitStats>
<Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="22" WaitCount="21699" />
<Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="25" WaitCount="36506" />
<Wait WaitType="IO_QUEUE_LIMIT" WaitTimeMs="349" WaitCount="12" />
<Wait WaitType="PAGEIOLATCH_SH" WaitTimeMs="1256" WaitCount="18" />
<Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="8640" WaitCount="3477" />
</WaitStats>
<QueryTimeStats CpuTime="14579" ElapsedTime="24528" />
<RelOp AvgRowSize="11" EstimateCPU="0.040206" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="167.875">
<OutputList>
<ColumnReference Column="Expr1039" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1039" />
<ScalarOperator ScalarString="(1)">
<Const ConstValue="(1)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="9" EstimateCPU="2.16762" EstimateIO="0.027231" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="167.835">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="18002" ActualCPUms="14336" 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="[price]" Column="ProductId" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [price].[ProductId]=[devdatabase].[dbo].[ProductStatus].[ProductId] as [pps].[ProductId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[price]" Column="ProductId" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="39" EstimateCPU="2.1682" EstimateIO="0.039438" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402060" LogicalOp="Inner Join" NodeId="2" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="17399" ActualCPUms="13805" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [currency].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="3" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16784" ActualCPUms="13279" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [asdir].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="4" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16212" ActualCPUms="12760" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [asnum].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="5" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15665" ActualCPUms="12235" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [asname].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="6" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="15098" ActualCPUms="11732" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [state].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="7" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="14533" ActualCPUms="11203" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [county].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="8" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="13833" ActualCPUms="10682" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [country].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="9" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="13090" ActualCPUms="10157" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [city].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="10" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="12443" ActualCPUms="9636" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [zip].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="11" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="11895" ActualCPUms="9105" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [mls].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="12" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="11240" ActualCPUms="8549" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [webCode].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="13" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="10685" ActualCPUms="8034" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [vip].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="14" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="9623" ActualCPUms="7496" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [cls].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="15" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="366184" ActualRowsRead="9" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="9102" ActualCPUms="6992" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Metadata].[ProductId] as [propName].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="16" 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="[ProductStatus]" 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="8475" ActualCPUms="6399" 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="17" 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="[ProductStatus]" 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="7386" ActualCPUms="5969" 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="[ProductStatus]" 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].[ProductStatus].[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="[ProductStatus]" 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="18" 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="[ProductStatus]" 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="6059" ActualCPUms="5054" 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="[ProductStatus]" 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].[ProductStatus].[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="[ProductStatus]" 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="19" 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="[ProductStatus]" 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="4971" ActualCPUms="4124" 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="[ProductStatus]" 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].[ProductStatus].[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="[ProductStatus]" 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="20" 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="[ProductStatus]" 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="3560" ActualCPUms="3070" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[plistDate]" Column="ProductId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[ProductStatus].[ProductId] as [pps].[ProductId]=[devdatabase].[dbo].[Metadata].[ProductId] as [plistDate].[ProductId]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductStatus]" 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="21" 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="[ProductStatus]" 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="1765" ActualCPUms="1731" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[devdatabase].[dbo].[Properties].[ProductId] as [p].[ProductId]=[devdatabase].[dbo].[ProductStatus].[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="[ProductStatus]" 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="22" 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="939" ActualCPUms="920" 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="23" 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="141" ActualCPUms="141" ActualScans="1" ActualLogicalReads="6242" ActualPhysicalReads="0" ActualReadAheads="256" 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="24" 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="140" ActualCPUms="140" ActualScans="1" ActualLogicalReads="1917" ActualPhysicalReads="0" ActualReadAheads="7" 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="25" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="2.23274" TableCardinality="1010400">
<OutputList>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="404562" ActualRowsRead="404562" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="145" ActualCPUms="145" ActualScans="1" ActualLogicalReads="2426" ActualPhysicalReads="0" 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="[ProductStatus]" Alias="[pps]" Column="ProductId" />
</DefinedValue>
</DefinedValues>
<Object Database="[devdatabase]" Schema="[dbo]" Table="[ProductStatus]" Index="[IX_ProductStatus_CurrentAndStatusIds]" Alias="[pps]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[ProductStatus]" 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="26" 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="501" ActualCPUms="293" ActualScans="1" ActualLogicalReads="3923" ActualPhysicalReads="0" ActualReadAheads="4087" 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="27" 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="268" ActualCPUms="172" ActualScans="1" ActualLogicalReads="4329" ActualPhysicalReads="0" ActualReadAheads="4468" 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="28" 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="159" ActualCPUms="158" ActualScans="1" ActualLogicalReads="3619" ActualPhysicalReads="0" ActualReadAheads="702" 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="29" 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="232" ActualCPUms="155" ActualScans="1" ActualLogicalReads="3746" ActualPhysicalReads="0" ActualReadAheads="3865" 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="30" 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="238" ActualCPUms="205" ActualScans="1" ActualLogicalReads="4956" ActualPhysicalReads="0" ActualReadAheads="5069" 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="31" 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="178" ActualCPUms="161" ActualScans="1" ActualLogicalReads="3409" ActualPhysicalReads="0" ActualReadAheads="989" 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="32" 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="695" ActualCPUms="170" ActualScans="1" ActualLogicalReads="2565" ActualPhysicalReads="3" ActualReadAheads="2699" 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="33" 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="200" ActualCPUms="161" ActualScans="1" ActualLogicalReads="2565" ActualPhysicalReads="0" ActualReadAheads="84" 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="34" 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="266" ActualCPUms="165" ActualScans="1" ActualLogicalReads="3337" ActualPhysicalReads="0" ActualReadAheads="618" 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="35" 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="172" ActualCPUms="157" ActualScans="1" ActualLogicalReads="3447" ActualPhysicalReads="0" ActualReadAheads="934" 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="36" 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="281" ActualCPUms="155" ActualScans="1" ActualLogicalReads="3520" ActualPhysicalReads="0" ActualReadAheads="1023" 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="37" 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="386" ActualCPUms="166" ActualScans="1" ActualLogicalReads="3193" ActualPhysicalReads="0" ActualReadAheads="3370" 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="38" 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="338" ActualCPUms="159" ActualScans="1" ActualLogicalReads="3111" ActualPhysicalReads="0" ActualReadAheads="3293" 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="39" 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="201" ActualCPUms="166" ActualScans="1" ActualLogicalReads="2884" ActualPhysicalReads="0" ActualReadAheads="447" 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="40" 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="222" ActualCPUms="158" ActualScans="1" ActualLogicalReads="3922" ActualPhysicalReads="0" ActualReadAheads="1146" 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="41" 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="177" ActualCPUms="154" ActualScans="1" ActualLogicalReads="2700" ActualPhysicalReads="0" ActualReadAheads="486" 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="42" 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="212" ActualCPUms="160" ActualScans="1" ActualLogicalReads="2489" ActualPhysicalReads="0" ActualReadAheads="57" 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="43" 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="275" ActualCPUms="186" ActualScans="1" ActualLogicalReads="3616" ActualPhysicalReads="0" ActualReadAheads="270" 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>
<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="[price]" Column="ProductId" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="402054" ActualRowsRead="402054" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="241" ActualCPUms="169" ActualScans="1" ActualLogicalReads="3183" ActualPhysicalReads="0" ActualReadAheads="635" 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="[price]" Column="ProductId" />
</DefinedValue>
</DefinedValues>
<Object Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Index="[IX_Metadata_FieldNameId]" Alias="[price]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[devdatabase]" Schema="[dbo]" Table="[Metadata]" Alias="[price]" Column="FieldNameId" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="{guid'A4FB29A2-0620-4C15-809C-BB843AB8E7F4'}">
<Const ConstValue="{guid'A4FB29A2-0620-4C15-809C-BB843AB8E7F4'}" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Merge>
</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