- <?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.565" Build="16.0.937.2220" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="14" StatementEstRows="100" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="150" StatementSubTreeCost="26.3365" StatementText="select quotelinei0_.id as col_0_0_ from quote_line_item quotelinei0_ left outer join quote_line_item_quantity quantities1_ on quotelinei0_.id=quantities1_.quote_line_item_id and (quantities1_.order_number in (0)) 
where quotelinei0_.quote_id=188713 and 1=1 and (quotelinei0_.validation in (@P0 , @P1 , @P2 , @P3 , @P4 , @P5 , @P6 , @P7 , @P8 , @P9 , @P10 , @P11)) 
and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 
and (select count(quotelinei2_.id) from quote_line_item quotelinei2_
where quotelinei2_.quote_id=quotelinei0_.quote_id and quotelinei2_.tti_manufacturer_cost_markup=quotelinei0_.tti_manufacturer_cost_markup and quotelinei2_.tti_part_number_cost_markup=quotelinei0_.tti_part_number_cost_markup 
and quotelinei2_.branch_name<>quotelinei0_.branch_name)>0 order by case when quantities1_.ext_cost is null 
then 1 else 0 end asc, quantities1_.ext_cost desc offset 0 rows fetch next @P12 rows only" StatementType="SELECT" QueryHash="0xB1F5732552AFDA4B" QueryPlanHash="0x4B4A8A47C2010BAC" RetrievedFromCache="true" StatementSqlHandle="0x0900F676D5153E968A5EB994485C31C23AE90000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="13" 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="8" MemoryGrant="18560" CachedPlanSize="112" CompileTime="14" CompileCPU="14" CompileMemory="1552">
- <ThreadStat Branches="3" UsedThreads="24">
- <ThreadReservation NodeId="0" ReservedThreads="24" />
- </ThreadStat>
- <MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="1904" RequiredMemory="17152" DesiredMemory="18560" RequestedMemory="18560" GrantWaitTime="0" GrantedMemory="18560" MaxUsedMemory="13056" MaxQueryMemory="8634392" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="566169" EstimatedPagesCached="566169" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="60592272" />
- <OptimizerStatsUsage>
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item_quantity]" Statistics="[line_item_quantity_id]" ModificationCount="112254" SamplingPercent="0.656431" LastUpdate="2023-03-24T17:12:56.23" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_00000005_607251E5]" ModificationCount="10318" SamplingPercent="0.775984" LastUpdate="2023-03-27T11:18:59.87" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_strong_high_quote_history]" ModificationCount="10318" SamplingPercent="0.775153" LastUpdate="2023-03-27T11:18:54.89" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[IX_TEST_QLI]" ModificationCount="10318" SamplingPercent="0.775153" LastUpdate="2023-03-27T11:19:14.3" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_00000037_607251E5]" ModificationCount="10318" SamplingPercent="0.767102" LastUpdate="2023-03-27T11:19:00.83" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[nci_wi_quote_line_item_EF56004AEA7F17F960312DD391220A4A]" ModificationCount="10318" SamplingPercent="0.775984" LastUpdate="2023-03-27T11:19:11.57" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item_quantity]" Statistics="[nci_wi_quote_line_item_quantity_8DD934E7C1A4E66FB0408305BF0193B8]" ModificationCount="77100" SamplingPercent="0.655837" LastUpdate="2023-03-24T20:44:40.76" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_strong_medium_quote_history]" ModificationCount="10318" SamplingPercent="0.775153" LastUpdate="2023-03-27T11:18:55.31" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_0000000A_607251E5]" ModificationCount="10318" SamplingPercent="0.761664" LastUpdate="2023-03-27T11:18:56.66" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_0000000E_607251E5]" ModificationCount="10318" SamplingPercent="0.781352" LastUpdate="2023-03-27T11:18:57.44" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[PK_quote_line_item_id]" ModificationCount="0" SamplingPercent="0.761664" LastUpdate="2023-03-27T11:18:51.61" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_quote_id]" ModificationCount="10318" SamplingPercent="0.751951" LastUpdate="2023-03-27T11:18:54.44" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_00000004_607251E5]" ModificationCount="10318" SamplingPercent="0.75963" LastUpdate="2023-03-27T11:18:58.98" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_00000038_607251E5]" ModificationCount="10318" SamplingPercent="0.761664" LastUpdate="2023-03-27T11:18:59.94" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_additional]" ModificationCount="10318" SamplingPercent="0.75963" LastUpdate="2023-03-27T11:18:56.59" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[nci_wi_quote_line_item_EA6A2593B179EBA418ABCF38AACCDB76]" ModificationCount="10318" SamplingPercent="0.77305" LastUpdate="2023-03-27T11:19:11.44" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item_quantity]" Statistics="[nci_wi_quote_line_item_quantity_D30A2CFEEF016EAC83F4601BF6EEC0EC]" ModificationCount="137362" SamplingPercent="0.654927" LastUpdate="2023-03-24T14:10:16.6" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[nci_wi_quote_line_item_70FF60494E1660CEE41B522F992CFE0E]" ModificationCount="10318" SamplingPercent="0.751951" LastUpdate="2023-03-27T11:19:10.89" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item_quantity]" Statistics="[PK_quote_line_item_quantity_id]" ModificationCount="144787" SamplingPercent="0.662075" LastUpdate="2023-03-23T18:28:26.46" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_part_alias_client_date]" ModificationCount="10318" SamplingPercent="0.767519" LastUpdate="2023-03-27T11:18:56.5" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_strong_low_quote_history]" ModificationCount="10318" SamplingPercent="0.775153" LastUpdate="2023-03-27T11:18:55.75" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_quote_id_preferred_line]" ModificationCount="10318" SamplingPercent="0.751951" LastUpdate="2023-03-27T11:19:11.66" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[IX_quote_line_item_quote_id_preferred_line_branch_name]" ModificationCount="10318" SamplingPercent="0.751951" LastUpdate="2023-03-27T11:19:13.88" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item_quantity]" Statistics="[quote_line_item_quantity_quote_line_item_id_order_number]" ModificationCount="154125" SamplingPercent="0.658449" LastUpdate="2023-03-24T12:53:49.51" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_00000010_607251E5]" ModificationCount="10318" SamplingPercent="0.781352" LastUpdate="2023-03-27T11:18:56.98" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_0000000F_607251E5]" ModificationCount="10318" SamplingPercent="0.781352" LastUpdate="2023-03-27T11:18:57.36" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[nci_wi_quote_line_item_E5C949D7C8464034C5506749A24BE01F]" ModificationCount="10318" SamplingPercent="0.761664" LastUpdate="2023-03-27T11:19:10.81" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_00000036_607251E5]" ModificationCount="10318" SamplingPercent="0.768411" LastUpdate="2023-03-27T11:19:03.26" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[_WA_Sys_0000001C_607251E5]" ModificationCount="10318" SamplingPercent="0.754328" LastUpdate="2023-03-27T11:18:58.9" />
- <StatisticsInfo Database="[4e543cd9-86ff-441c-ace4-c0c3542f0a17]" Schema="[dbo]" Table="[quote_line_item]" Statistics="[quote_line_item_cheapest_index]" ModificationCount="10318" SamplingPercent="0.775153" LastUpdate="2023-03-27T11:18:54.28" />
- </OptimizerStatsUsage>
- <WaitStats>
- <Wait WaitType="CXSYNC_PORT" WaitTimeMs="312610" WaitCount="41" />
- <Wait WaitType="CXPACKET" WaitTimeMs="298826" WaitCount="129" />
- <Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="337" WaitCount="30699" />
- <Wait WaitType="RESOURCE_GOVERNOR_IDLE" WaitTimeMs="229" WaitCount="25" />
- <Wait WaitType="LATCH_EX" WaitTimeMs="5" WaitCount="14" />
- <Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="5" WaitCount="1632" />
- <Wait WaitType="CXSYNC_CONSUMER" WaitTimeMs="3" WaitCount="14" />
- </WaitStats>
- <QueryTimeStats CpuTime="123665" ElapsedTime="123761" />
- <RelOp AvgRowSize="15" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="26.3365">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="123761" ActualCPUms="0" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[@P12],0)">
- <Identifier>
- <ColumnReference Column="ConstExpr1006">
- <ScalarOperator>
- <Convert DataType="bigint" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P12" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="36" EstimateCPU="0.028962" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" EstimateRowsWithoutRowGoal="9192.59" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="26.3365">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="123761" ActualCPUms="0" />
- </RunTimeInformation>
- <Parallelism>
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Expr1005" />
- </OrderByColumn>
- <OrderByColumn Ascending="false">
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="36" EstimateCPU="0.0613629" EstimateIO="0.00140766" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="100" EstimateRowsWithoutRowGoal="9192.59" LogicalOp="Sort" NodeId="2" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="26.3075">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <MemoryFractions Input="1" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96775" ActualCPUms="12" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="123758" ActualCPUms="123454" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96821" ActualCPUms="59" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96774" ActualCPUms="12" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96773" ActualCPUms="11" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96778" ActualCPUms="15" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96779" ActualCPUms="17" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96774" ActualCPUms="11" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="688" OutputMemoryGrant="304" UsedMemoryGrant="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" />
- </RunTimeInformation>
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Expr1005" />
- </OrderByColumn>
- <OrderByColumn Ascending="false">
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="36" EstimateCPU="0.000114907" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9192.59" EstimateRowsWithoutRowGoal="9192.59" LogicalOp="Compute Scalar" NodeId="3" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="26.2447">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- <ColumnReference Column="Expr1005" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="CASE WHEN [sqldb-uat-iq-02].[dbo].[quote_line_item_quantity].[ext_cost] as [quantities1_].[ext_cost] IS NULL THEN (1) ELSE (0) END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="32" EstimateCPU="0.00411914" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="9192.59" LogicalOp="Left Outer Join" NodeId="4" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="26.2446">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96775" ActualCPUms="12" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="123758" ActualCPUms="123454" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96821" ActualCPUms="59" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96774" ActualCPUms="12" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96773" ActualCPUms="11" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96778" ActualCPUms="15" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96779" ActualCPUms="17" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96774" ActualCPUms="11" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- <ColumnReference Column="Expr1007" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="0.0600646" EstimateIO="0.252004" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="7373.97" LogicalOp="Right Semi Join" NodeId="6" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="2.08478">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" ActualRowsRead="21537" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96775" ActualCPUms="12" ActualScans="363" ActualLogicalReads="6213" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" ActualRowsRead="874421702" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="123758" ActualCPUms="123454" ActualScans="368" ActualLogicalReads="4323436" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" ActualRowsRead="197402" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96821" ActualCPUms="59" ActualScans="342" ActualLogicalReads="7572" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" ActualRowsRead="22274" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96774" ActualCPUms="12" ActualScans="346" ActualLogicalReads="5617" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualRowsRead="15877" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96773" ActualCPUms="11" ActualScans="339" ActualLogicalReads="5277" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualRowsRead="29591" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96778" ActualCPUms="15" ActualScans="385" ActualLogicalReads="6305" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualRowsRead="14985" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96779" ActualCPUms="17" ActualScans="359" ActualLogicalReads="5545" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" ActualRowsRead="19563" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96774" ActualCPUms="11" ActualScans="375" ActualLogicalReads="5825" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Merge ManyToMany="true">
- <InnerSideJoinColumns>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_part_number_cost_markup" />
- </InnerSideJoinColumns>
- <OuterSideJoinColumns>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_part_number_cost_markup" />
- </OuterSideJoinColumns>
- <Residual>
- <ScalarOperator ScalarString="[sqldb-uat-iq-02].[dbo].[quote_line_item].[tti_manufacturer_cost_markup] as [quotelinei2_].[tti_manufacturer_cost_markup]=[sqldb-uat-iq-02].[dbo].[quote_line_item].[tti_manufacturer_cost_markup] as [quotelinei0_].[tti_manufacturer_cost_markup] AND [sqldb-uat-iq-02].[dbo].[quote_line_item].[tti_part_number_cost_markup] as [quotelinei2_].[tti_part_number_cost_markup]=[sqldb-uat-iq-02].[dbo].[quote_line_item].[tti_part_number_cost_markup] as [quotelinei0_].[tti_part_number_cost_markup] AND [sqldb-uat-iq-02].[dbo].[quote_line_item].[branch_name] as [quotelinei2_].[branch_name]<>[sqldb-uat-iq-02].[dbo].[quote_line_item].[branch_name] as [quotelinei0_].[branch_name]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_manufacturer_cost_markup" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_manufacturer_cost_markup" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_part_number_cost_markup" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_part_number_cost_markup" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="branch_name" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="branch_name" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Residual>
- <RelOp AvgRowSize="470" EstimateCPU="0.605669" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="61617.1" LogicalOp="Repartition Streams" NodeId="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1.0874">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_part_number_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="branch_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="2680" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96761" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="7" ActualRows="31975" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="29" ActualCPUms="25" />
- <RunTimeCountersPerThread Thread="6" ActualRows="2702" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96760" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="5" ActualRows="2417" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96761" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="4" ActualRows="2390" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96759" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="2604" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96760" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2497" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96760" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="2484" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="96760" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_part_number_cost_markup" />
- </PartitionColumns>
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_manufacturer_cost_markup" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_part_number_cost_markup" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="470" EstimateCPU="0.00849198" EstimateIO="0.473239" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="61617.1" EstimatedRowsRead="61617.1" LogicalOp="Index Seek" NodeId="8" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.481731" TableCardinality="21536500">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_part_number_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="branch_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="7168" ActualRowsRead="7168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="7" ActualRows="7168" ActualRowsRead="7168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="7791" ActualRowsRead="7791" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="5798" ActualRowsRead="5798" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="1" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="3774" ActualRowsRead="3774" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="0" ActualScans="1" ActualLogicalReads="48" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="5416" ActualRowsRead="5416" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="7084" ActualRowsRead="7084" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="5550" ActualRowsRead="5550" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="16" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_manufacturer_cost_markup" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="tti_part_number_cost_markup" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="branch_name" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Index="[IX_TEST_QLI]" Alias="[quotelinei2_]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei2_]" Column="quote_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(188713)">
- <Const ConstValue="(188713)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- <RelOp AvgRowSize="48" EstimateCPU="0.173689" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="25085.9" LogicalOp="Repartition Streams" NodeId="9" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.685304">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_part_number_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="branch_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="2680" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="7" ActualRows="31975" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="16" ActualCPUms="10" />
- <RunTimeCountersPerThread Thread="6" ActualRows="2702" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="5" ActualRows="2417" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="4" ActualRows="2390" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="2604" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2497" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="4" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="2484" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_part_number_cost_markup" />
- </PartitionColumns>
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_manufacturer_cost_markup" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_part_number_cost_markup" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="73" EstimateCPU="0.00849198" EstimateIO="0.473239" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="25085.9" EstimatedRowsRead="61617.1" LogicalOp="Index Seek" NodeId="10" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.481731" TableCardinality="21536500">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_manufacturer_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_part_number_cost_markup" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="branch_name" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="7084" ActualRowsRead="7084" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="7" ActualRows="7168" ActualRowsRead="7168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="7791" ActualRowsRead="7791" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="5550" ActualRowsRead="5550" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="7168" ActualRowsRead="7168" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="3774" ActualRowsRead="3774" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" ActualScans="1" ActualLogicalReads="48" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="5416" ActualRowsRead="5416" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="5798" ActualRowsRead="5798" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="3" ActualCPUms="3" ActualScans="1" ActualLogicalReads="68" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="16" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_manufacturer_cost_markup" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="tti_part_number_cost_markup" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="branch_name" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Index="[IX_TEST_QLI]" Alias="[quotelinei0_]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="quote_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(188713)">
- <Const ConstValue="(188713)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P11] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P10] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P9] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P8] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P7] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P6] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P5] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P4] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P3] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P2] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P1] OR [sqldb-uat-iq-02].[dbo].[quote_line_item].[validation] as [quotelinei0_].[validation]=[@P0]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P11" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P10" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P9" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P8" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P7" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P6" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P5" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P4" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P3" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P2" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P1" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="validation" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P0" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Merge>
- </RelOp>
- <RelOp AvgRowSize="24" EstimateCPU="0.000158176" EstimateIO="0.003125" EstimateRebinds="7372.97" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.0691" EstimatedRowsRead="1.0691" LogicalOp="Index Seek" NodeId="11" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="24.1557" TableCardinality="32111900">
- <OutputList>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="ext_cost" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Index="[quote_line_item_quantity_quote_line_item_id_order_number]" Alias="[quantities1_]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="quote_line_item_id" />
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item_quantity]" Alias="[quantities1_]" Column="order_number" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[sqldb-uat-iq-02].[dbo].[quote_line_item].[id] as [quotelinei0_].[id]">
- <Identifier>
- <ColumnReference Database="[sqldb-uat-iq-02]" Schema="[dbo]" Table="[quote_line_item]" Alias="[quotelinei0_]" Column="id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Top>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@P12" ParameterDataType="int" ParameterRuntimeValue="(200)" />
- <ColumnReference Column="@P0" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'QRG Offer'" />
- <ColumnReference Column="@P1" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'Valid Mfg. Part'" />
- <ColumnReference Column="@P2" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'Need More Info'" />
- <ColumnReference Column="@P3" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'Obsolete'" />
- <ColumnReference Column="@P4" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'Franchised'" />
- <ColumnReference Column="@P5" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'Non-Franchised'" />
- <ColumnReference Column="@P6" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'Series Non-Franchised'" />
- <ColumnReference Column="@P7" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'MFG Non-Franchised'" />
- <ColumnReference Column="@P8" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'MFG Non-Franchised'" />
- <ColumnReference Column="@P9" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'MFG Unresolvable'" />
- <ColumnReference Column="@P10" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'BLANK'" />
- <ColumnReference Column="@P11" ParameterDataType="nvarchar(4000)" ParameterRuntimeValue="N'Can''t ID'" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>