Advertisement
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.5" Build="13.0.4446.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="8" StatementEstRows="970391" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="18236.2" StatementText="SELECT wd.SourceCol1
 , vp.Col2
 , vp.Col3 
 FROM AppDB.MySchema.View_VP vp WITH (FORCESEEK)
 INNER JOIN #MyTemp wd ON wd.SourceCol1 = vp.Col1
 WHERE vp.Col3 > DATEADD(MONTH, @Months * -1, GETDATE())" StatementType="SELECT" QueryHash="0x46E5D8BB3AD5F421" QueryPlanHash="0x8F295C85F70A895B" RetrievedFromCache="true" StatementSqlHandle="0x09003E95EBFF5425141BC293F77C0C55D8590000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="1454628225" BatchSqlHandle="0x0300070081DDB35600C4AB0003A7000001000000000000000000000000000000000000000000000000000000" StatementParameterizationType="0" SecurityPolicyApplied="false">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan CachedPlanSize="96" CompileTime="14" CompileCPU="14" CompileMemory="904">
- <ThreadStat Branches="3" />
- <MissingIndexes>
- <MissingIndexGroup Impact="71.8365">
- <MissingIndex Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]">
- <ColumnGroup Usage="INEQUALITY">
- <Column Name="[Status]" ColumnId="10" />
- </ColumnGroup>
- <ColumnGroup Usage="INCLUDE">
- <Column Name="[Col4]" ColumnId="11" />
- <Column Name="[Col1]" ColumnId="16" />
- <Column Name="[P_Id]" ColumnId="23" />
- </ColumnGroup>
- </MissingIndex>
- </MissingIndexGroup>
- </MissingIndexes>
- <MemoryGrantInfo SerialRequiredMemory="2176" SerialDesiredMemory="3249528" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="705604" EstimatedPagesCached="2116812" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="207777928" />
- <TraceFlags IsCompileTime="true">
- <TraceFlag Value="3226" Scope="Global" />
- <TraceFlag Value="7412" Scope="Global" />
- <TraceFlag Value="7745" Scope="Global" />
- <TraceFlag Value="7752" Scope="Global" />
- </TraceFlags>
- <RelOp AvgRowSize="37" EstimateCPU="0.590538" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="970391" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="18236.2">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- <ColumnReference Column="Expr1003" />
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </OutputList>
- <Parallelism>
- <RelOp AvgRowSize="37" EstimateCPU="1.87284" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="970391" LogicalOp="Inner Join" NodeId="1" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="18235.6">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- <ColumnReference Column="Expr1003" />
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </OutputList>
- <MemoryFractions Input="0.000209401" Output="0.00524886" />
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[P_DB].[dbo].[LargeTable].[Col1] as [pp].[Col1]=#MyTemp.[SourceCol1] as [wd].[SourceCol1]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="27" EstimateCPU="0.0290288" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="114" LogicalOp="Distribute Streams" NodeId="2" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0339177">
- <OutputList>
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </OutputList>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </PartitionColumns>
- <RelOp AvgRowSize="27" EstimateCPU="0.0002824" EstimateIO="0.00460648" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="114" EstimatedRowsRead="114" LogicalOp="Table Scan" NodeId="3" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00488888" TableCardinality="114">
- <OutputList>
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </OutputList>
- <Warnings>
- <ColumnsWithNoStatistics>
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </ColumnsWithNoStatistics>
- </Warnings>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="#MyTemp" Alias="[wd]" Column="SourceCol1" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[tempdb]" Schema="[dbo]" Table="[#MyTemp]" Alias="[wd]" Storage="RowStore" />
- </TableScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- <RelOp AvgRowSize="37" EstimateCPU="0.0631262" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="970391" LogicalOp="Filter" NodeId="4" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="18233.7">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- <ColumnReference Column="Expr1003" />
- </OutputList>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="37" EstimateCPU="0.856341" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1052100" LogicalOp="Repartition Streams" NodeId="5" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="18233.7">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- <ColumnReference Column="Expr1003" />
- </OutputList>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- </PartitionColumns>
- <RelOp AvgRowSize="37" EstimateCPU="17.9326" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1052100" LogicalOp="Aggregate" NodeId="6" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="18232.8">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- <ColumnReference Column="Expr1003" />
- </OutputList>
- <MemoryFractions Input="0.0396853" Output="0.994751" />
- <Hash>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1003" />
- <ScalarOperator ScalarString="MAX([P_DB].[dbo].[LargeTable].[Col4] as [pp].[Col4])">
- <Aggregate AggType="MAX" Distinct="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col4" />
- </Identifier>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <HashKeysBuild>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </HashKeysBuild>
- <BuildResidual>
- <ScalarOperator ScalarString="[P_DB].[dbo].[LargeTable].[Col1] as [pp].[Col1] = [P_DB].[dbo].[LargeTable].[Col1] as [pp].[Col1] AND [P_DB].[dbo].[SmallTable].[Col2] as [pd].[Col2] = [P_DB].[dbo].[SmallTable].[Col2] as [pd].[Col2]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </BuildResidual>
- <RelOp AvgRowSize="37" EstimateCPU="9.9378" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12297800" LogicalOp="Repartition Streams" NodeId="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="18214.9">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col4" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </OutputList>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </PartitionColumns>
- <RelOp AvgRowSize="37" EstimateCPU="16.6488" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="12297800" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="18204.9">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col4" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </OutputList>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="P_Id" />
- <ColumnReference Column="Expr1009" />
- </OuterReferences>
- <RelOp AvgRowSize="39" EstimateCPU="16.6488" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="31863700" LogicalOp="Inner Join" NodeId="10" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="13150.5">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col4" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="P_Id" />
- </OutputList>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Column="Uniq1001" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="PY_Id" />
- <ColumnReference Column="Expr1008" />
- </OuterReferences>
- <RelOp AvgRowSize="40" EstimateCPU="155.339" EstimateIO="367.649" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="31863700" LogicalOp="Sort" NodeId="12" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="750.826">
- <OutputList>
- <ColumnReference Column="Uniq1001" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="PY_Id" />
- </OutputList>
- <MemoryFractions Input="0.999791" Output="0.960105" />
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="PY_Id" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Uniq1001" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="40" EstimateCPU="4.38128" EstimateIO="223.456" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="31863700" EstimatedRowsRead="31863700" LogicalOp="Index Seek" NodeId="13" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="227.838" TableCardinality="32273500">
- <OutputList>
- <ColumnReference Column="Uniq1001" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="PY_Id" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Uniq1001" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="PY_Id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Index="[ix_status_MHD_DDate]" Alias="[pp]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Status" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(3)">
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Status" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(4)">
- <Const ConstValue="(4)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="48" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="31863700" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="15" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="12383" TableCardinality="32273500">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col4" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="P_Id" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col4" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="Col1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="P_Id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Index="[ix_PY_Id]" Alias="[pp]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="PY_Id" />
- <ColumnReference Column="Uniq1001" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[P_DB].[dbo].[LargeTable].[PY_Id] as [pp].[PY_Id]">
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="PY_Id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[Uniq1001]">
- <Identifier>
- <ColumnReference Column="Uniq1001" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="30748500" EstimateRewinds="1115180" EstimatedExecutionMode="Row" EstimateRows="1" EstimatedRowsRead="1" LogicalOp="Clustered Index Seek" NodeId="16" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="5037.82" TableCardinality="6349">
- <OutputList>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="true" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="Col2" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Index="[PK_SmallTable]" Alias="[pd]" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[SmallTable]" Alias="[pd]" Column="P_Id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[P_DB].[dbo].[LargeTable].[P_Id] as [pp].[P_Id]">
- <Identifier>
- <ColumnReference Database="[P_DB]" Schema="[dbo]" Table="[LargeTable]" Alias="[pp]" Column="P_Id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Hash>
- </RelOp>
- </Parallelism>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[Expr1003]>dateadd(month,[@Months]*(-1),getdate())">
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1003" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1006">
- <ScalarOperator>
- <Intrinsic FunctionName="dateadd">
- <ScalarOperator>
- <Const ConstValue="(2)" />
- </ScalarOperator>
- <ScalarOperator>
- <Arithmetic Operation="MULT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@Months" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(-1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="getdate" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </Hash>
- </RelOp>
- </Parallelism>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@Months" ParameterDataType="int" ParameterCompiledValue="(6)" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement