Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Tuning a query help Expand / Collapse
Author
Message
Posted Thursday, December 20, 2012 3:59 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 12:58 AM
Points: 576, Visits: 1,532
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="[i]" 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="[i]" 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="[i]" 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="[i]" 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="[i]" 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="[i]" 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 [i].[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="[i]" 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="[i]" 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="[i]" 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 [i].[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="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" Column="MARITEMPRICEGROUPID" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[DynamicsAX].[dbo].[INVENTTABLE].[MARITEMPRICEGROUPID] as [i].[MARITEMPRICEGROUPID]=[PriceData].[dbo].[AxProductPriceExtract].[Product] as [pr].[Product]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" Column="MARITEMPRICEGROUPID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" 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="[i]" Column="ITEMID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" Column="MARITEMPRICEGROUPID" />
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" Column="ITEMID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" Column="MARITEMPRICEGROUPID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" Column="MARPACKSIZE" />
</DefinedValue>
</DefinedValues>
<Object Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Index="[I_175ITEMIDX]" Alias="[i]" IndexKind="Clustered" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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 [i].[MARCHILDITEMFLAG]=(0) AND PROBE([Bitmap1036],[DynamicsAX].[dbo].[INVENTTABLE].[MARITEMPRICEGROUPID] as [i].[MARITEMPRICEGROUPID])">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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="[i]" 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 [i].[ITEMID]">
<Identifier>
<ColumnReference Database="[DynamicsAX]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[i]" 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>

Post #1398893
Posted Thursday, December 20, 2012 5:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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
Post #1398913
Posted Thursday, December 20, 2012 5:22 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:10 AM
Points: 262, Visits: 2,851
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.
Post #1398919
Posted Thursday, December 20, 2012 6:18 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 12:58 AM
Points: 576, Visits: 1,532
Hi there - I have attached the files for the definitions and also the execution plan

Thanks


  Post Attachments 
Query.rar (8 views, 20.81 KB)
Post #1398937
Posted Thursday, December 20, 2012 8:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 11,927, Visits: 10,968
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1399021
Posted Thursday, December 20, 2012 8:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 11,927, Visits: 10,968

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1399024
Posted Thursday, December 20, 2012 11:12 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, March 31, 2014 2:22 PM
Points: 3,725, Visits: 7,067
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; They'll drag you down to their level and beat you with experience"
Post #1399075
Posted Thursday, December 20, 2012 1:47 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:05 PM
Points: 185, Visits: 901
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?



Alex Suprun
Post #1399098
Posted Thursday, December 20, 2012 10:55 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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
Post #1399194
Posted Thursday, December 20, 2012 11:58 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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()
set @c = @c + 1
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
Post #1399214
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse