Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="1" StatementEstRows="100" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.425495" StatementText="SELECT TOP 100
*
FROM InventTrans
 JOIN
 InventDim
 ON InventDim.DATAAREAID = 'dat' AND 
 InventDim.INVENTDIMID = InventTrans.INVENTDIMID
WHERE InventTrans.DATAAREAID = 'dat' AND 
 InventTrans.ITEMID = '027743' AND 
 InventDim.INVENTLOCATIONID = 'КзРЦ Алмат' AND 
 InventDim.ECC_BUSINESSUNITID = 'Казахстан';

 --UPDATE STATISTICS INVENTTRANS(I_177ITEMIDX) WITH FULLSCAN
 --UPDATE STATISTICS INVENTDIM(I_698ECC_BUSUNITLOCIDX) WITH FULLSCAN

" StatementType="SELECT" QueryHash="0xB2EDC20B34443F70" QueryPlanHash="0x2C47CA8FD22D9FEC">
- <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="0" MemoryGrant="20872" CachedPlanSize="152" CompileTime="51" CompileCPU="27" CompileMemory="1024">
- <RelOp AvgRowSize="1093" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.425495">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSISSUE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTY" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPOSTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CURRENCYCODE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSTYPE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSFER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEEXPECTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEFINANCIAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSRECEIPT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPRETURNED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICERETURNED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHERPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTADJUSTMENT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATEREQUESTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATECONFIRMED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTYSETTLED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSETTLED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VALUEOPEN" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DIRECTION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ACTIVITYNUMBER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATESTATUS" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSTD" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATECLOSED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PICKINGROUTEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTOPERATIONS" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDRETURN" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJCATEGORYID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMFIXED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEINVENT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CUSTVENDAC" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDTYPE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="REVENUEAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJADJUSTREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETBOOKID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTREFTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROBABILITYID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNO_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMBOMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TAXAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="NONFINANCIALTRANSFERINVENTCL73" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNOPHYSICAL_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMIDSALES_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDSALES_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSIT_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDDELIVERY_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFTYPE_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTBATCHID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="WMSLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSERIALID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSITEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTGTDID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_BUSINESSUNITID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_SEASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_DEFECTREASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_CUSTINVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSIZEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTCOLORID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTPROFILEID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTOWNERID_RU" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(100)">
- <Const ConstValue="(100)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="1093" EstimateCPU="0.183329" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.425485">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSISSUE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTY" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPOSTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CURRENCYCODE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSTYPE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSFER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEEXPECTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEFINANCIAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSRECEIPT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPRETURNED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICERETURNED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHERPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTADJUSTMENT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATEREQUESTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATECONFIRMED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTYSETTLED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSETTLED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VALUEOPEN" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DIRECTION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ACTIVITYNUMBER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATESTATUS" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSTD" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATECLOSED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PICKINGROUTEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTOPERATIONS" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDRETURN" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJCATEGORYID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMFIXED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEINVENT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CUSTVENDAC" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDTYPE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="REVENUEAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJADJUSTREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETBOOKID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTREFTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROBABILITYID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNO_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMBOMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TAXAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="NONFINANCIALTRANSFERINVENTCL73" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNOPHYSICAL_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMIDSALES_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDSALES_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSIT_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDDELIVERY_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFTYPE_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTBATCHID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="WMSLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSERIALID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSITEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTGTDID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_BUSINESSUNITID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_SEASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_DEFECTREASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_CUSTINVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSIZEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTCOLORID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTPROFILEID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTOWNERID_RU" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- <ColumnReference Column="Expr1008" />
- </OuterReferences>
- <RelOp AvgRowSize="340" EstimateCPU="0.183329" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="100" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0938419">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTBATCHID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="WMSLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSERIALID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSITEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTGTDID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_BUSINESSUNITID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_SEASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_DEFECTREASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_CUSTINVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSIZEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTCOLORID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTPROFILEID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTOWNERID_RU" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- <ColumnReference Column="Expr1007" />
- </OuterReferences>
- <RelOp AvgRowSize="270" EstimateCPU="0.0224922" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="12.2688" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0469385">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTBATCHID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="WMSLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSERIALID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSITEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTGTDID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_BUSINESSUNITID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_SEASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_DEFECTREASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_CUSTINVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSIZEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTCOLORID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTPROFILEID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTOWNERID_RU" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="15385" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Column="Expr1006" />
- </OuterReferences>
- <RelOp AvgRowSize="63" EstimateCPU="0.00607601" EstimateIO="0.0431233" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="12.2688" LogicalOp="Index Seek" NodeId="8" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00337928" TableCardinality="85833000">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_BUSINESSUNITID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="15385" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTLOCATIONID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_BUSINESSUNITID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Index="[I_698ECC_BUSUNITLOCIDX]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_BUSINESSUNITID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTLOCATIONID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="N'dat'">
- <Const ConstValue="N'dat'" />
- </ScalarOperator>
- <ScalarOperator ScalarString="N'Казахстан'">
- <Const ConstValue="N'Казахстан'" />
- </ScalarOperator>
- <ScalarOperator ScalarString="N'КзРЦ Алмат'">
- <Const ConstValue="N'КзРЦ Алмат'" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="246" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="12.2667" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="10" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0435086" TableCardinality="85833000">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTBATCHID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="WMSLOCATIONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSERIALID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSITEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTGTDID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_SEASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_DEFECTREASONID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_CUSTINVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSIZEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTCOLORID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTPROFILEID_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTOWNERID_RU" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="15385" ActualEndOfScans="0" ActualExecutions="15385" />
- </RunTimeInformation>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTBATCHID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="WMSLOCATIONID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSERIALID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSITEID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECVERSION" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="RECID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTGTDID_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_SEASONID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_DEFECTREASONID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="ECC_CUSTINVENTDIMID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTSIZEID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTCOLORID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTPROFILEID_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTOWNERID_RU" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Index="[I_698DIMIDIDX]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTDIM].[DATAAREAID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="DATAAREAID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTDIM].[INVENTDIMID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="79" EstimateCPU="0.000165966" EstimateIO="0.003125" EstimateRebinds="12.2667" EstimateRewinds="2.91666E-05" EstimateRows="8.15077" LogicalOp="Index Seek" NodeId="40" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0436129" TableCardinality="183916000">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="15385" ActualExecutions="15385" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Index="[I_177DIMIDIDX]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="N'dat'">
- <Const ConstValue="N'dat'" />
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTDIM].[INVENTDIMID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTDIM]" Column="INVENTDIMID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="N'027743'">
- <Const ConstValue="N'027743'" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="777" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="99.9987" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="42" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.331228" TableCardinality="183916000">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSISSUE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTY" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPOSTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CURRENCYCODE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSTYPE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSFER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEEXPECTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEFINANCIAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSRECEIPT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPRETURNED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICERETURNED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHERPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTADJUSTMENT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATEREQUESTED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATECONFIRMED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTYSETTLED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSETTLED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VALUEOPEN" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DIRECTION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ACTIVITYNUMBER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATESTATUS" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSTD" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATECLOSED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PICKINGROUTEID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTOPERATIONS" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDRETURN" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJCATEGORYID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMFIXED" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEINVENT" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CUSTVENDAC" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDTYPE" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="REVENUEAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJADJUSTREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETBOOKID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTREFTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROBABILITYID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECVERSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNO_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMBOMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TAXAMOUNTPHYSICAL" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="NONFINANCIALTRANSFERINVENTCL73" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNOPHYSICAL_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMIDSALES_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDSALES_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSIT_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDDELIVERY_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFTYPE_RU" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFID_RU" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSISSUE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEPHYSICAL" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTY" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPOSTED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CURRENCYCODE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSTYPE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSREFID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICEID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHER" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSFER" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEEXPECTED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEFINANCIAL" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTPHYSICAL" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STATUSRECEIPT" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPRETURNED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVOICERETURNED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PACKINGSLIPID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VOUCHERPHYSICAL" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTADJUSTMENT" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATEREQUESTED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="SHIPPINGDATECONFIRMED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="QTYSETTLED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSETTLED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="VALUEOPEN" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DIRECTION" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ACTIVITYNUMBER" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATESTATUS" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTSTD" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATECLOSED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PICKINGROUTEID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDFATHER" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="COSTAMOUNTOPERATIONS" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDRETURN" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJCATEGORYID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMFIXED" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATEINVENT" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="CUSTVENDAC" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDREFID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TRANSCHILDTYPE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="REVENUEAMOUNTPHYSICAL" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROJADJUSTREFID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ASSETBOOKID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTREFTRANSID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="PROBABILITYID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECVERSION" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNO_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="ITEMBOMID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="TAXAMOUNTPHYSICAL" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="NONFINANCIALTRANSFERINVENTCL73" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="STORNOPHYSICAL_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMIDSALES_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDSALES_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDTRANSIT_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSIDDELIVERY_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFTYPE_RU" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="GROUPREFID_RU" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Index="[I_177TRANSIDIDX]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[DATAAREAID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="DATAAREAID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[INVENTTRANSID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTTRANSID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[INVENTDIMID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="INVENTDIMID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[RECID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Column="RECID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Add Comment
Please, Sign In to add comment