December 20, 2012 at 3:59 am
Hi all - I am trying to tune the query below, as it was causing an issue on our server. I have already added the index below, which improved things somewhat but I still have a huge Index Scan as you can see from the attached Execution Plan.
The query uses a DISTINCT so should I be trying to re-design the query rather than perhaps using something like MAXDOP 1. (Which incidently I tried, however it recommended a slighjtly different index to the one already present)
Any help with how I can improve on this Index Scan would be appreciated. Below are the code, index and plan.
Thanks
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
USE PriceData
GO
DECLARE @CustAccount varchar(20),
@PriceDate datetime--,
SET @CustAccount = '105295'
SET @PriceDate = '01/01/13'
SELECT DISTINCT
g.PRICEQUOTEGROUP,
g.headerLeft,
g.headerRight,
g.HEADERLINE2,
p.textline1,
p.textline2,
p.textline3,
p.productcode,
p.extraquoteunit,
p.sqmPack,
p.Orderselect,
case when p.extraquoteunit <> '' then p.extraquoteunit else mod.unitid END UnitId,
g.SortOrder gsort,
p.SortOrder psort,
case when c.FACTOR is null then pr.price else round(pr.price / c.FACTOR , 2) END price,
case when c.FACTOR is null then i.MARPACKSIZE else 0 END PackSize,
i.MARPACKSIZE UnitsperPack,
pr.PriceList,
cu.name + ' ' + cu.MARBRANCHNAME CustName,
cu.ACCOUNTNUM
FROM
dynamicsAX.dbo.MARPRICEQUOTEPRODGRP g
join dynamicsAX.dbo.MARPRICEQUOTEPRODUCTS p WITH (NOLOCK)
on p.DATAAREAID = g.DATAAREAID and p.PRICEQUOTEGROUP = g.PRICEQUOTEGROUP
join PriceData.dbo.AxProductPriceExtract pr WITH (NOLOCK)
on p.productcode = pr.Product
join dynamicsAX.dbo.inventtable i WITH (NOLOCK)
on pr.product = i.MARItemPriceGroupID
join dynamicsax.dbo.CUSTTABLE cu WITH (NOLOCK)
on pr.PriceList = cu.MARITEMPRICEYARD
left outer join dynamicsAX.dbo.INVENTTABLEMODULE mod
on i.itemid = mod.itemid
left outer join dynamicsAX.dbo.UNITCONVERT c WITH (NOLOCK)
on p.dataareaid = c.DATAAREAID and i.ITEMID = c.ITEMID
and mod.UNITID = c.TOUNIT and p.extraquoteunit = c.FROMUNIT
WHERE
cu.ACCOUNTNUM = @CustAccount and
g.pricequote = 'Landscape2013' and
pr.FromDate <= @PriceDate and
pr.ToDate >= @PriceDate and
g.dataareaid = 'abb' and
p.dataareaid = 'abb' and
i.dataareaid = 'abb' and
cu.dataareaid = 'abb' and
mod.dataareaid = 'abb' and
i.MARCHILDITEMFLAG = 0 and
mod.MODULETYPE = 2 and
pr.price <> 9999.99 --and
-- g.IMPORTED = @NatStone
ORDER BY
gsort, psort
--OPTION (MAXDOP 1)
GO
SET STATISTICS IO OFF
GO
SET STATISTICS TIME OFF
CREATE NONCLUSTERED INDEX [IX_AXProductPriceExtract_Price_FromDate,ToDate]
ON [dbo].[AxProductPriceExtract] ([Price], [FromDate],[Todate])
INCLUDE ( [PriceList],[Product])
GO
<?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.1" Build="10.50.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="3" StatementEstRows="2209.75" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="154.467" StatementText="SELECT DISTINCT g.PRICEQUOTEGROUP, g.headerLeft, g.headerRight, g.HEADERLINE2, p.textline1, p.textline2, p.textline3, p.productcode, p.extraquoteunit, p.sqmPack, p.Orderselect, case when p.extraquoteunit <> '' then p.extraquoteunit else mod.unitid END UnitId, g.SortOrder gsort, p.SortOrder psort, case when c.FACTOR is null then pr.price else round(pr.price / c.FACTOR , 2) END price, case when c.FACTOR is null then i.MARPACKSIZE else 0 END PackSize, i.MARPACKSIZE UnitsperPack, pr.PriceList, cu.name + ' ' + cu.MARBRANCHNAME CustName, cu.ACCOUNTNUM FROM dynamicsAX.dbo.MARPRICEQUOTEPRODGRP g join dynamicsAX.dbo.MARPRICEQUOTEPRODUCTS p WITH (NOLOCK) on p.DATAAREAID = g.DATAAREAID and p.PRICEQUOTEGROUP = g.PRICEQUOTEGROUP join PriceData.dbo.AxProductPriceExtract pr WITH (NOLOCK) on p.productcode = pr.Product join dynamicsAX.dbo.inventtable i WITH (NOLOCK) on pr.product = i.MARItemPriceGroupID join dynamicsax.dbo.CUSTTABLE cu WITH (NOLOCK) on pr.PriceList = cu.MARITEMPRICEYARD left outer join dynamicsAX.dbo.INVENTTABLEMODULE mod on i.itemid = mod.itemid left outer join dynamicsAX.dbo.UNITCONVERT c WITH (NOLOCK) on p.dataareaid = c.DATAAREAID and i.ITEMID = c.ITEMID and mod.UNITID = c.TOUNIT and p.extraquoteunit = c.FROMUNIT WHERE cu.ACCOUNTNUM = @CustAccount and g.pricequote = 'Landscape2013' and pr.FromDate <= @PriceDate and pr.ToDate >= @PriceDate and g.dataareaid = 'abb' and p.dataareaid = 'abb' and i.dataareaid = 'abb' and cu.dataareaid = 'abb' and mod.dataareaid = 'abb' and i.MARCHILDITEMFLAG = 0 and mod.MODULETYPE = 2 and pr.price <> 9999.99 --and -- g.IMPORTED = @NatStone ORDER BY gsort, psort --OPTION (MAXDOP 1) " StatementType="SELECT" QueryHash="0x0209B5D545691730" QueryPlanHash="0xD6336457D60053CF">
<StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
<QueryPlan DegreeOfParallelism="24" MemoryGrant="100032" CachedPlanSize="288" CompileTime="1097" CompileCPU="538" CompileMemory="7024">
<RelOp AvgRowSize="628" EstimateCPU="0.0449761" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="154.467">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1017" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="869" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Parallelism>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="628" EstimateCPU="0.00319983" EstimateIO="0.000938438" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Distinct Sort" NodeId="1" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="154.422">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1017" />
<ColumnReference Column="Expr1018" />
</OutputList>
<MemoryFractions Input="0.263848" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRebinds="1" ActualRewinds="0" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRebinds="1" ActualRewinds="0" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRebinds="1" ActualRewinds="0" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRebinds="1" ActualRewinds="0" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRebinds="1" ActualRewinds="0" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRebinds="1" ActualRewinds="0" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRebinds="1" ActualRewinds="0" ActualRows="46" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRebinds="1" ActualRewinds="0" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRebinds="1" ActualRewinds="0" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRebinds="1" ActualRewinds="0" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRebinds="1" ActualRewinds="0" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRebinds="1" ActualRewinds="0" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRebinds="1" ActualRewinds="0" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRebinds="1" ActualRewinds="0" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRebinds="1" ActualRewinds="0" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRebinds="1" ActualRewinds="0" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1015" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1016" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1017" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1018" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="628" EstimateCPU="0.0447361" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Repartition Streams" NodeId="2" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="154.417">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1017" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1017" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Column="Expr1018" />
</PartitionColumns>
<RelOp AvgRowSize="628" EstimateCPU="1.84146E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Compute Scalar" NodeId="3" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="154.373">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1017" />
<ColumnReference Column="Expr1018" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1015" />
<ScalarOperator ScalarString="CASE WHEN [DynamicsAX].[dbo].[MARPRICEQUOTEPRODUCTS].[EXTRAQUOTEUNIT] as [p].[EXTRAQUOTEUNIT]<>N'' THEN [DynamicsAX].[dbo].[MARPRICEQUOTEPRODUCTS].[EXTRAQUOTEUNIT] as [p].[EXTRAQUOTEUNIT] ELSE [DynamicsAX].[dbo].[INVENTTABLEMODULE].[UNITID] as [mod].[UNITID] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="NE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N''" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1016" />
<ScalarOperator ScalarString="CASE WHEN [DynamicsAX].[dbo].[UNITCONVERT].[FACTOR] as [c].[FACTOR] IS NULL THEN CONVERT_IMPLICIT(numeric(38,10),[PriceData].[dbo].[AxProductPriceExtract].[Price] as [pr].[Price],0) ELSE round([PriceData].[dbo].[AxProductPriceExtract].[Price] as [pr].[Price]/[DynamicsAX].[dbo].[UNITCONVERT].[FACTOR] as [c].[FACTOR],(2)) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FACTOR" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="numeric" Precision="38" Scale="10" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Intrinsic FunctionName="round">
<ScalarOperator>
<Arithmetic Operation="DIV">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FACTOR" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1017" />
<ScalarOperator ScalarString="CASE WHEN [DynamicsAX].[dbo].[UNITCONVERT].[FACTOR] as [c].[FACTOR] IS NULL THEN [DynamicsAX].[dbo].[INVENTTABLE].[MARPACKSIZE] as .[MARPACKSIZE] ELSE (0.000000000000) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FACTOR" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0.000000000000)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="619" EstimateCPU="0.151618" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Right Outer Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="154.373">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FACTOR" />
<ColumnReference Column="Expr1018" />
</OutputList>
<MemoryFractions Input="0.377816" Output="0.476676" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="19" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="24" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="TOUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FROMUNIT" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[DynamicsAX].[dbo].[INVENTTABLE].[ITEMID] as .[ITEMID]=[DynamicsAX].[dbo].[UNITCONVERT].[ITEMID] as [c].[ITEMID] AND [DynamicsAX].[dbo].[INVENTTABLEMODULE].[UNITID] as [mod].[UNITID]=[DynamicsAX].[dbo].[UNITCONVERT].[TOUNIT] as [c].[TOUNIT] AND [DynamicsAX].[dbo].[MARPRICEQUOTEPRODUCTS].[EXTRAQUOTEUNIT] as [p].[EXTRAQUOTEUNIT]=[DynamicsAX].[dbo].[UNITCONVERT].[FROMUNIT] as [c].[FROMUNIT]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="ITEMID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="TOUNIT" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FROMUNIT" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="54" EstimateCPU="0.0501836" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="29245.3" LogicalOp="Repartition Streams" NodeId="5" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.316412">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FROMUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="TOUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FACTOR" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="ITEMID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="6" ActualRows="1234" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="1207" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="1213" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="1275" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="1280" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="1187" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="1233" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="1179" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="1167" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="1270" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="1217" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="1181" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="1267" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="1237" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="1215" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1190" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="1191" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1198" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="1216" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="1226" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="1193" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="1236" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="1266" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="1156" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="TOUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FROMUNIT" />
</PartitionColumns>
<RelOp AvgRowSize="54" EstimateCPU="0.0026939" EstimateIO="0.263535" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="29245.3" LogicalOp="Clustered Index Seek" NodeId="6" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.266229" TableCardinality="153380">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FROMUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="TOUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FACTOR" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="ITEMID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="5" ActualRows="1910" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="1914" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="361" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="1916" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="1919" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="1913" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="2020" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="2540" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="2027" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="1861" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="2558" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="1908" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="1977" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1915" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="2495" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FROMUNIT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="TOUNIT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="FACTOR" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="ITEMID" />
</DefinedValue>
</DefinedValues>
<Object Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Index="[I_486ITEMFROMTOIDX]" Alias="[c]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[UNITCONVERT]" Alias="[c]" Column="DATAAREAID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'abb'">
<Const ConstValue="N'abb'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="625" EstimateCPU="0.0454182" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Repartition Streams" NodeId="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="153.905">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="6" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="34" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="23" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="24" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="39" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</PartitionColumns>
<RelOp AvgRowSize="625" EstimateCPU="0.000769728" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="153.859">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="13" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="17" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="53" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="25" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<NestedLoops Optimized="false" WithUnorderedPrefetch="true">
<OuterReferences>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Column="Expr1037" />
</OuterReferences>
<RelOp AvgRowSize="618" EstimateCPU="0.00319983" EstimateIO="0.000938438" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Sort" NodeId="10" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="151.124">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<MemoryFractions Input="0.205661" Output="0.259475" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="13" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRebinds="1" ActualRewinds="0" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRebinds="1" ActualRewinds="0" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="17" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRebinds="1" ActualRewinds="0" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRebinds="1" ActualRewinds="0" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRebinds="1" ActualRewinds="0" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRebinds="1" ActualRewinds="0" ActualRows="53" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRebinds="1" ActualRewinds="0" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRebinds="1" ActualRewinds="0" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRebinds="1" ActualRewinds="0" ActualRows="25" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRebinds="1" ActualRewinds="0" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRebinds="1" ActualRewinds="0" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRebinds="1" ActualRewinds="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRebinds="1" ActualRewinds="0" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRebinds="1" ActualRewinds="0" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRebinds="1" ActualRewinds="0" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRebinds="1" ActualRewinds="0" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="618" EstimateCPU="0.000898082" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Inner Join" NodeId="11" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="151.12">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="13" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="17" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="19" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="28" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="53" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="25" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[DynamicsAX].[dbo].[MARPRICEQUOTEPRODUCTS].[PRICEQUOTEGROUP] as [p].[PRICEQUOTEGROUP]=[DynamicsAX].[dbo].[MARPRICEQUOTEPRODGRP].[PRICEQUOTEGROUP] as [g].[PRICEQUOTEGROUP]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="339" EstimateCPU="0.0326104" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="150.256" LogicalOp="Distribute Streams" NodeId="12" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.038036">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="9" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
</PartitionColumns>
<RelOp AvgRowSize="339" EstimateCPU="0.000322281" EstimateIO="0.00510333" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="150.256" LogicalOp="Clustered Index Seek" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00542561" TableCardinality="614">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTEGROUP" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLEFT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERLINE2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="SORTORDER" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="HEADERRIGHT" />
</DefinedValue>
</DefinedValues>
<Object Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Index="[I_31095IDXPRODGRP]" Alias="[g]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="DATAAREAID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODGRP]" Alias="[g]" Column="PRICEQUOTE" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'abb'">
<Const ConstValue="N'abb'" />
</ScalarOperator>
<ScalarOperator ScalarString="N'Landscape2013'">
<Const ConstValue="N'Landscape2013'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="307" EstimateCPU="0.0031998" EstimateIO="0.000938438" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Sort" NodeId="14" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="151.081">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<MemoryFractions Input="0.155369" Output="0.108608" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRebinds="1" ActualRewinds="0" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRebinds="1" ActualRewinds="0" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRebinds="1" ActualRewinds="0" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRebinds="1" ActualRewinds="0" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRebinds="1" ActualRewinds="0" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRebinds="1" ActualRewinds="0" ActualRows="100" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRebinds="1" ActualRewinds="0" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRebinds="1" ActualRewinds="0" ActualRows="50" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRebinds="1" ActualRewinds="0" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRebinds="1" ActualRewinds="0" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRebinds="1" ActualRewinds="0" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRebinds="1" ActualRewinds="0" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRebinds="1" ActualRewinds="0" ActualRows="99" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRebinds="1" ActualRewinds="0" ActualRows="70" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRebinds="1" ActualRewinds="0" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRebinds="1" ActualRewinds="0" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="307" EstimateCPU="0.0340204" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Repartition Streams" NodeId="15" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="151.077">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="100" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="99" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="70" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
</PartitionColumns>
<RelOp AvgRowSize="307" EstimateCPU="0.35168" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2209.75" LogicalOp="Inner Join" NodeId="16" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="151.043">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<MemoryFractions Input="0.182553" Output="0.261153" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="70" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="87" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARITEMPRICEGROUPID" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[DynamicsAX].[dbo].[INVENTTABLE].[MARITEMPRICEGROUPID] as .[MARITEMPRICEGROUPID]=[PriceData].[dbo].[AxProductPriceExtract].[Product] as [pr].[Product]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARITEMPRICEGROUPID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="295" EstimateCPU="0.00159735" EstimateIO="0.00124073" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="757.245" LogicalOp="Bitmap Create" NodeId="17" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="141.373">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="70" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Bitmap1036" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</HashKeys>
<RelOp AvgRowSize="295" EstimateCPU="0.00159735" EstimateIO="0.00124073" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="757.245" LogicalOp="Inner Join" NodeId="18" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="141.373">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="70" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[DynamicsAX].[dbo].[MARPRICEQUOTEPRODUCTS].[PRODUCTCODE] as [p].[PRODUCTCODE]=[PriceData].[dbo].[AxProductPriceExtract].[Product] as [pr].[Product]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="157" EstimateCPU="0.000727883" EstimateIO="0.000938438" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="599.775" LogicalOp="Sort" NodeId="19" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="141.266">
<OutputList>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<MemoryFractions Input="0.0256585" Output="0.017331" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="145" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRebinds="1" ActualRewinds="0" ActualRows="140" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRebinds="1" ActualRewinds="0" ActualRows="150" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRebinds="1" ActualRewinds="0" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRebinds="1" ActualRewinds="0" ActualRows="153" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="145" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRebinds="1" ActualRewinds="0" ActualRows="148" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRebinds="1" ActualRewinds="0" ActualRows="128" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRebinds="1" ActualRewinds="0" ActualRows="162" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRebinds="1" ActualRewinds="0" ActualRows="150" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRebinds="1" ActualRewinds="0" ActualRows="177" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRebinds="1" ActualRewinds="0" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRebinds="1" ActualRewinds="0" ActualRows="131" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="125" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRebinds="1" ActualRewinds="0" ActualRows="133" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRebinds="1" ActualRewinds="0" ActualRows="169" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRebinds="1" ActualRewinds="0" ActualRows="133" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRebinds="1" ActualRewinds="0" ActualRows="192" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRebinds="1" ActualRewinds="0" ActualRows="153" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="157" EstimateCPU="0.028562" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="599.775" LogicalOp="Bitmap Create" NodeId="20" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="141.264">
<OutputList>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="6" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="150" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="172" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="148" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="128" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="162" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="177" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="170" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="192" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="154" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Bitmap1035" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</HashKeys>
<RelOp AvgRowSize="157" EstimateCPU="0.028562" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="599.775" LogicalOp="Repartition Streams" NodeId="21" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="141.264">
<OutputList>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="6" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="150" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="172" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="148" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="128" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="162" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="177" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="170" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="192" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="154" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</PartitionColumns>
<RelOp AvgRowSize="157" EstimateCPU="0.0188237" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="599.775" LogicalOp="Inner Join" NodeId="22" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="141.236">
<OutputList>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Column="Expr1018" />
</OutputList>
<MemoryFractions Input="0.0957916" Output="0.0701331" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="20" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="188" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="154" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="230" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="129" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="125" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="145" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="178" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="162" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="132" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="147" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="200" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="179" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="150" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="136" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="158" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[PriceData].[dbo].[AxProductPriceExtract].[PriceList] as [pr].[PriceList]=[DynamicsAX].[dbo].[CUSTTABLE].[MARITEMPRICEYARD] as [cu].[MARITEMPRICEYARD]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="138" EstimateCPU="0.0285116" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Bitmap Create" NodeId="23" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="0.0317948">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="20" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Bitmap>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Opt_Bitmap1029" />
</DefinedValue>
</DefinedValues>
<HashKeys>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
</HashKeys>
<RelOp AvgRowSize="138" EstimateCPU="0.0285116" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="24" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317948">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
<ColumnReference Column="Expr1018" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="20" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp AvgRowSize="138" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="25" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0032832">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
<ColumnReference Column="Expr1018" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1018" />
<ScalarOperator ScalarString="([DynamicsAX].[dbo].[CUSTTABLE].[NAME] as [cu].[NAME]+N' ')+[DynamicsAX].[dbo].[CUSTTABLE].[MARBRANCHNAME] as [cu].[MARBRANCHNAME]">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="NAME" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N' '" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARBRANCHNAME" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="105" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="26" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="107940">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="NAME" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARBRANCHNAME" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="NAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARBRANCHNAME" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="MARITEMPRICEYARD" />
</DefinedValue>
</DefinedValues>
<Object Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Index="[I_077ACCOUNTIDX]" Alias="[cu]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="DATAAREAID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[CUSTTABLE]" Alias="[cu]" Column="ACCOUNTNUM" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'abb'">
<Const ConstValue="N'abb'" />
</ScalarOperator>
<ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(20),[@CustAccount],0)">
<Identifier>
<ColumnReference Column="ConstExpr1019">
<ScalarOperator>
<Convert DataType="nvarchar" Length="40" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@CustAccount" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
</Bitmap>
</RelOp>
<RelOp AvgRowSize="66" EstimateCPU="1.86203" EstimateIO="136.818" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="599.775" LogicalOp="Index Scan" NodeId="31" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="138.68" TableCardinality="20312900">
<OutputList>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="20" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="188" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="154" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="146" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="125" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="145" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="178" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="132" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="162" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="200" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="179" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="147" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="150" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="136" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="129" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="158" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="230" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Product" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
</DefinedValue>
</DefinedValues>
<Object Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Index="[IX_AXProductPriceExtract_Price_FromDate,ToDate]" Alias="[pr]" IndexKind="NonClustered" />
<Predicate>
<ScalarOperator ScalarString="[PriceData].[dbo].[AxProductPriceExtract].[FromDate] as [pr].[FromDate]<=[@PriceDate] AND [PriceData].[dbo].[AxProductPriceExtract].[Todate] as [pr].[Todate]>=[@PriceDate] AND [PriceData].[dbo].[AxProductPriceExtract].[Price] as [pr].[Price]<>(9999.99) AND PROBE([Opt_Bitmap1029],[PriceData].[dbo].[AxProductPriceExtract].[PriceList] as [pr].[PriceList])">
<Logical Operation="AND">
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="FromDate" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@PriceDate" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="GE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Todate" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="@PriceDate" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="NE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="Price" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(9999.99)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Opt_Bitmap1029" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PriceData]" Schema="[dbo]" Table="[AxProductPriceExtract]" Alias="[pr]" Column="PriceList" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</Bitmap>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="147" EstimateCPU="0.00598364" EstimateIO="0.000938438" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3858.08" LogicalOp="Sort" NodeId="34" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.104388">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
</OutputList>
<MemoryFractions Input="0.0855163" Output="0.0855163" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRebinds="1" ActualRewinds="0" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRebinds="1" ActualRewinds="0" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRebinds="1" ActualRewinds="0" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRebinds="1" ActualRewinds="0" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRebinds="1" ActualRewinds="0" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRebinds="1" ActualRewinds="0" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRebinds="1" ActualRewinds="0" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRebinds="1" ActualRewinds="0" ActualRows="70" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRebinds="1" ActualRewinds="0" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRebinds="1" ActualRewinds="0" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRebinds="1" ActualRewinds="0" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRebinds="1" ActualRewinds="0" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRebinds="1" ActualRewinds="0" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRebinds="1" ActualRewinds="0" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRebinds="1" ActualRewinds="0" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRebinds="1" ActualRewinds="0" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRebinds="1" ActualRewinds="0" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRebinds="1" ActualRewinds="0" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRebinds="1" ActualRewinds="0" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRebinds="1" ActualRewinds="0" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="147" EstimateCPU="0.0338162" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3858.08" LogicalOp="Repartition Streams" NodeId="35" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0974658">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="70" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="62" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
</PartitionColumns>
<RelOp AvgRowSize="147" EstimateCPU="0.00036674" EstimateIO="0.0632829" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3858.08" LogicalOp="Clustered Index Seek" NodeId="36" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0636496" TableCardinality="3895">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="11" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="109" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="104" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="87" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="94" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="94" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="95" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="74" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="89" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="81" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="57" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="42" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="31" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="EXTRAQUOTEUNIT" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SORTORDER" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRICEQUOTEGROUP" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="SQMPACK" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="TEXTLINE3" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="ORDERSELECT" />
</DefinedValue>
</DefinedValues>
<Object Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Index="[I_31096IDXQUOTEPRODUCTS]" Alias="[p]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="DATAAREAID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'abb'">
<Const ConstValue="N'abb'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="PROBE([Bitmap1035],[DynamicsAX].[dbo].[MARPRICEQUOTEPRODUCTS].[PRODUCTCODE] as [p].[PRODUCTCODE])">
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bitmap1035" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[MARPRICEQUOTEPRODUCTS]" Alias="[p]" Column="PRODUCTCODE" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
</Bitmap>
</RelOp>
<RelOp AvgRowSize="45" EstimateCPU="0.0618911" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="60718" LogicalOp="Repartition Streams" NodeId="38" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="9.318">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARITEMPRICEGROUPID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="23" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="6" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="27" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="33" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARITEMPRICEGROUPID" />
</PartitionColumns>
<RelOp AvgRowSize="49" EstimateCPU="0.00581826" EstimateIO="9.24776" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="60718" LogicalOp="Clustered Index Seek" NodeId="39" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="9.25358" TableCardinality="218342">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARITEMPRICEGROUPID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="6" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="17" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="22" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="12" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="5" ActualRows="58" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="15" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="11" ActualRows="50" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="14" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="18" ActualRows="81" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="8" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="17" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="20" ActualRows="35" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="19" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="24" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="16" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="9" ActualRows="21" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="7" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="10" ActualRows="8" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="23" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="21" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="13" ActualRows="17" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARITEMPRICEGROUPID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARPACKSIZE" />
</DefinedValue>
</DefinedValues>
<Object Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Index="[I_175ITEMIDX]" Alias="" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="DATAAREAID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'abb'">
<Const ConstValue="N'abb'" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[DynamicsAX].[dbo].[INVENTTABLE].[MARCHILDITEMFLAG] as .[MARCHILDITEMFLAG]=(0) AND PROBE([Bitmap1036],[DynamicsAX].[dbo].[INVENTTABLE].[MARITEMPRICEGROUPID] as .[MARITEMPRICEGROUPID])">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARCHILDITEMFLAG" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="PROBE">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Bitmap1036" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="MARITEMPRICEGROUPID" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="16" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1288.35" EstimateRewinds="920.396" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="42" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="2.73427" TableCardinality="655035">
<OutputList>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="2" ActualRows="56" ActualEndOfScans="0" ActualExecutions="56" />
<RunTimeCountersPerThread Thread="6" ActualRows="13" ActualEndOfScans="0" ActualExecutions="13" />
<RunTimeCountersPerThread Thread="9" ActualRows="50" ActualEndOfScans="0" ActualExecutions="50" />
<RunTimeCountersPerThread Thread="1" ActualRows="17" ActualEndOfScans="0" ActualExecutions="17" />
<RunTimeCountersPerThread Thread="14" ActualRows="43" ActualEndOfScans="0" ActualExecutions="43" />
<RunTimeCountersPerThread Thread="18" ActualRows="42" ActualEndOfScans="0" ActualExecutions="42" />
<RunTimeCountersPerThread Thread="23" ActualRows="19" ActualEndOfScans="0" ActualExecutions="19" />
<RunTimeCountersPerThread Thread="4" ActualRows="21" ActualEndOfScans="0" ActualExecutions="21" />
<RunTimeCountersPerThread Thread="19" ActualRows="50" ActualEndOfScans="0" ActualExecutions="50" />
<RunTimeCountersPerThread Thread="7" ActualRows="21" ActualEndOfScans="0" ActualExecutions="21" />
<RunTimeCountersPerThread Thread="3" ActualRows="28" ActualEndOfScans="0" ActualExecutions="28" />
<RunTimeCountersPerThread Thread="10" ActualRows="38" ActualEndOfScans="0" ActualExecutions="38" />
<RunTimeCountersPerThread Thread="21" ActualRows="53" ActualEndOfScans="0" ActualExecutions="53" />
<RunTimeCountersPerThread Thread="8" ActualRows="29" ActualEndOfScans="0" ActualExecutions="29" />
<RunTimeCountersPerThread Thread="16" ActualRows="16" ActualEndOfScans="0" ActualExecutions="16" />
<RunTimeCountersPerThread Thread="24" ActualRows="25" ActualEndOfScans="0" ActualExecutions="25" />
<RunTimeCountersPerThread Thread="15" ActualRows="65" ActualEndOfScans="0" ActualExecutions="65" />
<RunTimeCountersPerThread Thread="11" ActualRows="3" ActualEndOfScans="0" ActualExecutions="3" />
<RunTimeCountersPerThread Thread="17" ActualRows="37" ActualEndOfScans="0" ActualExecutions="37" />
<RunTimeCountersPerThread Thread="13" ActualRows="54" ActualEndOfScans="0" ActualExecutions="54" />
<RunTimeCountersPerThread Thread="20" ActualRows="45" ActualEndOfScans="0" ActualExecutions="45" />
<RunTimeCountersPerThread Thread="22" ActualRows="40" ActualEndOfScans="0" ActualExecutions="40" />
<RunTimeCountersPerThread Thread="12" ActualRows="62" ActualEndOfScans="0" ActualExecutions="62" />
<RunTimeCountersPerThread Thread="5" ActualRows="44" ActualEndOfScans="0" ActualExecutions="44" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="UNITID" />
</DefinedValue>
</DefinedValues>
<Object Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Index="[I_176ITEMMODULEIDX]" Alias="[mod]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="DATAAREAID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLEMODULE]" Alias="[mod]" Column="MODULETYPE" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="N'abb'">
<Const ConstValue="N'abb'" />
</ScalarOperator>
<ScalarOperator ScalarString="[DynamicsAX].[dbo].[INVENTTABLE].[ITEMID] as .[ITEMID]">
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="" Column="ITEMID" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(2)">
<Const ConstValue="(2)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</Parallelism>
</RelOp>
</Hash>
</RelOp>
</ComputeScalar>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
</Parallelism>
</RelOp>
<ParameterList>
<ColumnReference Column="@PriceDate" ParameterRuntimeValue="'2013-01-01 00:00:00.000'" />
<ColumnReference Column="@CustAccount" ParameterRuntimeValue="'105295'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
December 20, 2012 at 5:02 am
can you post the graphical exec plan too ? and complete tabla and index definition ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2012 at 5:22 am
I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.
They're not a magic 'go faster' stripe, they're actually quite a dangerous option which can lead to queries completely missing data, reading it multiple times and, effectively returning garbage.
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 20, 2012 at 6:18 am
Hi there - I have attached the files for the definitions and also the execution plan
Thanks
December 20, 2012 at 8:42 am
andrew gothard (12/20/2012)
I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.They're not a magic 'go faster' stripe, they're actually quite a dangerous option which can lead to queries completely missing data, reading it multiple times and, effectively returning garbage.
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
+1
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 20, 2012 at 8:50 am
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 20, 2012 at 11:12 am
I'm not a big fan of reading XML query plans but a quick search through the XML revealed several IMPLICIT_CONVERSIONS, which depending on the number of records this occurs on, can adversely affect performance. Please make sure you are assigning the proper datatypes in your CASE statements and WHERE clause items.
Ex: If Customer Account in stored as an integer, don't declare it and pass it as a varchar(20)
(example only)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 20, 2012 at 1:47 pm
I believe that the index you created is far away from perfect.
First you need to find the most selective condition, please post the results of the following queries:
DECLARE @CustAccount varchar(20),
@PriceDate datetime--,
SET @CustAccount = '105295'
SET @PriceDate = '01/01/13'
SELECT COUNT(*)
FROM PriceData.dbo.AxProductPriceExtract pr
WHERE pr.FromDate <= @PriceDate and
pr.ToDate >= @PriceDate
SELECT COUNT(*)
FROM PriceData.dbo.AxProductPriceExtract pr
WHERE pr.price <> 9999.99
SELECT COUNT(*)
FROM PriceData.dbo.AxProductPriceExtract pr
join dynamicsax.dbo.CUSTTABLE cu WITH (NOLOCK)
on pr.PriceList = cu.MARITEMPRICEYARD
WHERE cu.ACCOUNTNUM = @CustAccount and
cu.dataareaid = 'abb'
Also you can try to use OPTION(RECOMPILE)
Is it a stored procedure you are trying to optimize? Do you know that when you are running it as a query you may get completely different plan and performance due to parameter sniffing?
December 20, 2012 at 10:55 pm
Sean Lange (12/20/2012)
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
new learning for me. i am straight away going to test it 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2012 at 11:58 pm
Bhuvnesh (12/20/2012)
Sean Lange (12/20/2012)
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
new learning for me. i am straight away going to test it 🙂
Sean , i did a test btu result are not impressive or i am overlooking somthing (OR amount of data is small ? )
use AdventureWorks2008R2
GO
set NOCOUNT ON
if exists ( select 1 from sys.objects where name = 'tbl_Distance' )
drop table tbl_Distance
Go
create table tbl_Distance
(
id int not null,
distance decimal (15,3),
uniqueid nvarchar(40)
)
GO
declare @C int
set @C = 1
while (@c < = 3000)
begin
insert into tbl_Distance (id, distance,uniqueid)
select @C , @C* 123.43, newid()
insert into tbl_Distance (id, distance,uniqueid)
select @C*2 , @C* 13.3, newid()
insert into tbl_Distance (id, distance,uniqueid)
select @C*3 , @C* 1.5, newid()
end
GO
create index idx on tbl_Distance (distance)
Query
select * from tbl_Distance
where distance <> 370.290
select * from tbl_Distance
where distance < 370.290 or distance > 370.290
results :
SQL Server Execution Times:
CPU time = 16 ms, elapsed time = 326 ms.
SQL Server Execution Times:
CPU time = 47 ms, elapsed time = 364 ms.
and
Table 'tbl_Distance'. Scan count 1, logical reads 190, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'tbl_Distance'. Scan count 1, logical reads 190, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 21, 2012 at 2:06 am
Hi all thanks for the replies I will be testing and posting results back as soon as I can. Its our last day at work here and I have various tasks I need to get done before we go on holiday, so have a Merry Christmas and Happy New Year, and see you in 2013.
Thanks
December 21, 2012 at 8:14 am
Bhuvnesh (12/20/2012)
Bhuvnesh (12/20/2012)
Sean Lange (12/20/2012)
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
new learning for me. i am straight away going to test it 🙂
Sean , i did a test btu result are not impressive or i am overlooking somthing (OR amount of data is small ? )
It was low hanging fruit and only likely a piece of the puzzle. We did get ddl but without any data it is hard to test performance.
The reason you are not seeing any difference in your two queries is because you are selecting only from a single table which is going to be an index scan. Are you familiar with SARGability? Not equals is a nonSARGable predicate. Do a quick search for sargable and you will find lots of material covering the topic.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply