SET STATISTICS IO ONGOSET STATISTICS TIME ONGOUSE PriceDataGODECLARE @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.ACCOUNTNUMFROM 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 = @NatStoneORDER BY gsort, psort--OPTION (MAXDOP 1)GOSET STATISTICS IO OFFGOSET 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>
DECLARE @CustAccount varchar(20), @PriceDate datetime--,SET @CustAccount = '105295'SET @PriceDate = '01/01/13'SELECT COUNT(*)FROM PriceData.dbo.AxProductPriceExtract prWHERE pr.FromDate <= @PriceDate and pr.ToDate >= @PriceDateSELECT COUNT(*)FROM PriceData.dbo.AxProductPriceExtract prWHERE pr.price <> 9999.99SELECT 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'
use AdventureWorks2008R2GOset NOCOUNT ONif exists ( select 1 from sys.objects where name = 'tbl_Distance' ) drop table tbl_Distance Gocreate table tbl_Distance (id int not null,distance decimal (15,3),uniqueid nvarchar(40))GOdeclare @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 GOcreate index idx on tbl_Distance (distance)
select * from tbl_Distance where distance <> 370.290select * from tbl_Distance where distance < 370.290 or distance > 370.290
