InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 03:12:59 GMT20http://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspx[quote][b]Bhuvnesh (12/20/2012)[/b][hr][quote][b]Bhuvnesh (12/20/2012)[/b][hr][quote][b]Sean Lange (12/20/2012)[/b][hr][quote]pr.price <> 9999.99[/quote]Try making this a SARGable predicate by removing the <> and replacing with > OR <pr.price < 9999.99 OR pr.price > 9999.99[/quote] new learning for me. i am straight away going to test it :-)[/quote]Sean , i did a test btu result are not impressive or i am overlooking somthing (OR amount of data is small ? )[/quote]It was low hanging fruit and only likely a piece of the puzzle. We did get ddl but without any data it is hard to test performance. The reason you are not seeing any difference in your two queries is because you are selecting only from a single table which is going to be an index scan. Are you familiar with SARGability? Not equals is a nonSARGable predicate. Do a quick search for sargable and you will find lots of material covering the topic.Fri, 21 Dec 2012 08:14:26 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspxHi all thanks for the replies I will be testing and posting results back as soon as I can. Its our last day at work here and I have various tasks I need to get done before we go on holiday, so have a Merry Christmas and Happy New Year, and see you in 2013.ThanksFri, 21 Dec 2012 02:06:50 GMTKwisatz78http://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspx[quote][b]Bhuvnesh (12/20/2012)[/b][hr][quote][b]Sean Lange (12/20/2012)[/b][hr][quote]pr.price <> 9999.99[/quote]Try making this a SARGable predicate by removing the <> and replacing with > OR <pr.price < 9999.99 OR pr.price > 9999.99[/quote] new learning for me. i am straight away going to test it :-)[/quote]Sean , i did a test btu result are not impressive or i am overlooking somthing (OR amount of data is small ? )[code="sql"]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)[/code]Query [code="sql"]select * from tbl_Distance where distance <> 370.290select * from tbl_Distance where distance < 370.290 or distance > 370.290[/code]results :[quote] SQL Server Execution Times: CPU time = 16 ms, elapsed time = 326 ms. SQL Server Execution Times: CPU time = 47 ms, elapsed time = 364 ms.[/quote]and [quote]Table 'tbl_Distance'. Scan count 1, logical reads 190, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table 'tbl_Distance'. Scan count 1, logical reads 190, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.[/quote]Thu, 20 Dec 2012 23:58:45 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspx[quote][b]Sean Lange (12/20/2012)[/b][hr][quote]pr.price <> 9999.99[/quote]Try making this a SARGable predicate by removing the <> and replacing with > OR <pr.price < 9999.99 OR pr.price > 9999.99[/quote] new learning for me. i am straight away going to test it :-)Thu, 20 Dec 2012 22:55:28 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspxI believe that the index you created is far away from perfect.First you need to find the most selective condition, please post the results of the following queries:[code="sql"]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'[/code]Also you can try to use OPTION(RECOMPILE)Is it a stored procedure you are trying to optimize? Do you know that when you are running it as a query you may get completely different plan and performance due to parameter sniffing?Thu, 20 Dec 2012 13:47:32 GMTAlexander Suprunhttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspxI'm not a big fan of reading XML query plans but a quick search through the XML revealed several IMPLICIT_CONVERSIONS, which depending on the number of records this occurs on, can adversely affect performance. Please make sure you are assigning the proper datatypes in your CASE statements and WHERE clause items.Ex: If Customer Account in stored as an integer, don't declare it and pass it as a varchar(20)(example only)Thu, 20 Dec 2012 11:12:20 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspx[quote]pr.price <> 9999.99[/quote]Try making this a SARGable predicate by removing the <> and replacing with > OR <pr.price < 9999.99 OR pr.price > 9999.99Thu, 20 Dec 2012 08:50:44 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspx[quote][b]andrew gothard (12/20/2012)[/b][hr]I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.They're not a magic 'go faster' stripe, they're actually quite a dangerous option which can lead to queries completely missing data, reading it multiple times and, effectively returning garbage.http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx[/quote]+1Thu, 20 Dec 2012 08:42:38 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspxHi there - I have attached the files for the definitions and also the execution planThanksThu, 20 Dec 2012 06:18:45 GMTKwisatz78http://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspxI know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.They're not a magic 'go faster' stripe, they're actually quite a dangerous option which can lead to queries completely missing data, reading it multiple times and, effectively returning garbage.http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspxThu, 20 Dec 2012 05:22:58 GMTandrew gothardhttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspxcan you post the graphical exec plan too ? and complete tabla and index definition ?Thu, 20 Dec 2012 05:02:38 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1398893-391-1.aspxHi all - I am trying to tune the query below, as it was causing an issue on our server. I have already added the index below, which improved things somewhat but I still have a huge Index Scan as you can see from the attached Execution Plan.The query uses a DISTINCT so should I be trying to re-design the query rather than perhaps using something like MAXDOP 1. (Which incidently I tried, however it recommended a slighjtly different index to the one already present)Any help with how I can improve on this Index Scan would be appreciated. Below are the code, index and plan.Thanks[code="sql"]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[/code][code="sql"]CREATE NONCLUSTERED INDEX [IX_AXProductPriceExtract_Price_FromDate,ToDate] ON [dbo].[AxProductPriceExtract] ([Price], [FromDate],[Todate])INCLUDE ( [PriceList],[Product]) GO[/code][code="xml"]<?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>[/code]Thu, 20 Dec 2012 03:59:36 GMTKwisatz78