Created
August 16, 2017 17:50
-
-
Save fuzzzerd/992cae89916937144f464a25cac564ed to your computer and use it in GitHub Desktop.
SELECT 1 FROM ... Query Plan
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-16"?> | |
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.6" Build="14.0.700.182" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
<BatchSequence> | |
<Batch> | |
<Statements> | |
<StmtSimple StatementCompId="1" StatementEstRows="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