Skip to content

Instantly share code, notes, and snippets.

/DIFERENCIAS_60d

Created November 18, 2013 08:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/7524487 to your computer and use it in GitHub Desktop.
Save anonymous/7524487 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DIFERENCIAS_60d
<?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.4000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="724.792" StatementText="SELECT DISTINCT &#xD;&#xA; R.InMaterial, 0 AS Anteil_proz_nom_VolIBP, R.LeadTime, R.Safety_stock, R.PuntoPed, R.TamLoteFij, R.ClasListNec, R.PlanNec, R.desc_CaracPlanNec, &#xD;&#xA; R.desc_GrupArt, R.desc_PlanNec, R.CaracPlanNec, R.Property1, R.Property2, R.Property3, '' AS Month_GI, R.year_GI, F.[Bimensual (60d)] AS Fecha, '60d' AS tipo, &#xD;&#xA; R.Descr, '6' AS registro&#xD;&#xA;FROM dbo.SCM_T_PP_OT_RECETA AS R LEFT OUTER JOIN&#xD;&#xA; PricingTool.dbo.LN_T_AUX_PP_Fechas AS F ON R.Date_GI &lt;&gt; F.DAY AND R.year_GI = F.YEAR&#xD;&#xA;WHERE (R.InMaterial IS NOT NULL) AND (F.[Bimensual (60d)] NOT IN&#xD;&#xA; (SELECT Fecha&#xD;&#xA; FROM dbo.SCM_V_PP_Consumo_60d AS C&#xD;&#xA; WHERE (InMaterial = R.InMaterial) AND (R.year_GI = year_GI)))" StatementType="SELECT" QueryHash="0xFCA580A3B7097732" QueryPlanHash="0x27A543917BB144FA">
<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="1" MemoryGrant="480632" CachedPlanSize="184" CompileTime="39" CompileCPU="37" CompileMemory="1456">
<RelOp AvgRowSize="312" EstimateCPU="0.000100312" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distinct Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="724.792">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1017" />
</OutputList>
<MemoryFractions Input="8.44113E-05" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="462" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="312" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="724.78">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
<ColumnReference Column="Expr1017" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1014" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1015" />
<ScalarOperator ScalarString="''">
<Const ConstValue="''" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1016" />
<ScalarOperator ScalarString="'60d'">
<Const ConstValue="'60d'" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1017" />
<ScalarOperator ScalarString="'6'">
<Const ConstValue="'6'" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="301" EstimateCPU="521.905" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Right Anti Semi Join" NodeId="2" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="724.78">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OutputList>
<MemoryFractions Input="0.790693" Output="0.99713" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="812006" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[SCM].[dbo].[SCM_T_PP_OT_RECETA].[InMaterial] as [R].[InMaterial]=[SCM].[dbo].[SCM_T_PP_OT_RECETA].[InMaterial] as [R].[InMaterial] AND [SCM].[dbo].[SCM_T_PP_OT_RECETA].[year_GI] as [R].[year_GI]=[SCM].[dbo].[SCM_T_PP_OT_RECETA].[year_GI] as [R].[year_GI] AND ([PricingTool].[dbo].[LN_T_AUX_PP_Fechas].[Bimensual (60d)] as [F].[Bimensual (60d)] IS NULL OR [PricingTool].[dbo].[LN_T_AUX_PP_Fechas].[Bimensual (60d)] as [F].[Bimensual (60d)] IS NULL OR [PricingTool].[dbo].[LN_T_AUX_PP_Fechas].[Bimensual (60d)] as [F].[Bimensual (60d)]=[PricingTool].[dbo].[LN_T_AUX_PP_Fechas].[Bimensual (60d)] as [F].[Bimensual (60d)])">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="19" EstimateCPU="19.7127" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="240271" LogicalOp="Distinct Sort" NodeId="3" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="47.345">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OutputList>
<MemoryFractions Input="0.989557" Output="0.209307" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="1350" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="301" EstimateCPU="1.86923" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="240271" LogicalOp="Right Outer Join" NodeId="4" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="27.6211">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OutputList>
<MemoryFractions Input="1" Output="0.010443" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="240270" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="DAY" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Date_GI" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[SCM].[dbo].[SCM_T_PP_OT_RECETA].[Date_GI] as [R].[Date_GI]=[PricingTool].[dbo].[LN_T_AUX_PP_Fechas].[DAY] as [F].[DAY]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Date_GI" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="DAY" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="14" EstimateCPU="0.0013626" EstimateIO="0.0112731" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1096" LogicalOp="Clustered Index Scan" NodeId="5" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0126357" TableCardinality="1096">
<OutputList>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="DAY" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1096" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="DAY" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</DefinedValue>
</DefinedValues>
<Object Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Index="[PK_LN_T_AUX_PP_Fechas]" Alias="[F]" TableReferenceId="2" IndexKind="Clustered" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="305" EstimateCPU="0.264455" EstimateIO="25.3594" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="240271" LogicalOp="Table Scan" NodeId="6" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="25.6239" TableCardinality="240271">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Date_GI" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="240270" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Date_GI" />
</DefinedValue>
</DefinedValues>
<Object Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" TableReferenceId="2" IndexKind="Heap" />
<Predicate>
<ScalarOperator ScalarString="[SCM].[dbo].[SCM_T_PP_OT_RECETA].[InMaterial] as [R].[InMaterial] IS NOT NULL">
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</TableScan>
</RelOp>
</Hash>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="301" EstimateCPU="129.779" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="79057500" LogicalOp="Right Outer Join" NodeId="8" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="155.531">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OutputList>
<MemoryFractions Input="0.209307" Output="0.00278557" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="87575241" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="YEAR" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[SCM].[dbo].[SCM_T_PP_OT_RECETA].[Date_GI] as [R].[Date_GI]&lt;&gt;[PricingTool].[dbo].[LN_T_AUX_PP_Fechas].[DAY] as [F].[DAY] AND [SCM].[dbo].[SCM_T_PP_OT_RECETA].[year_GI] as [R].[year_GI]=[PricingTool].[dbo].[LN_T_AUX_PP_Fechas].[YEAR] as [F].[YEAR]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="NE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Date_GI" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="DAY" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="YEAR" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="18" EstimateCPU="0.0013626" EstimateIO="0.0112731" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1096" LogicalOp="Clustered Index Scan" NodeId="9" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0126357" TableCardinality="1096">
<OutputList>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="DAY" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="YEAR" />
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1096" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="DAY" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="YEAR" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Alias="[F]" Column="Bimensual (60d)" />
</DefinedValue>
</DefinedValues>
<Object Database="[PricingTool]" Schema="[dbo]" Table="[LN_T_AUX_PP_Fechas]" Index="[PK_LN_T_AUX_PP_Fechas]" Alias="[F]" TableReferenceId="1" IndexKind="Clustered" />
</IndexScan>
</RelOp>
<RelOp AvgRowSize="305" EstimateCPU="0.264455" EstimateIO="25.3594" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="240271" LogicalOp="Table Scan" NodeId="10" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="25.6239" TableCardinality="240271">
<OutputList>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Date_GI" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="240270" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Descr" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="year_GI" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property2" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Property3" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="CaracPlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PuntoPed" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="TamLoteFij" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="ClasListNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="PlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Safety_stock" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_CaracPlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_GrupArt" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="desc_PlanNec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="LeadTime" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="Date_GI" />
</DefinedValue>
</DefinedValues>
<Object Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" TableReferenceId="1" IndexKind="Heap" />
<Predicate>
<ScalarOperator ScalarString="[SCM].[dbo].[SCM_T_PP_OT_RECETA].[InMaterial] as [R].[InMaterial] IS NOT NULL">
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[SCM]" Schema="[dbo]" Table="[SCM_T_PP_OT_RECETA]" Alias="[R]" Column="InMaterial" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</TableScan>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
</ComputeScalar>
</RelOp>
</Sort>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment