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.0" Build="9.00.4226.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="2" StatementEstRows="172.741" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.117549" StatementText="
SELECT attx.intAttributeID,attx.txtAttributeName,attx.txtAttributeLabel,attx.txtType,attx.txtEntity FROM
 AST_tblAttributes attx WHERE attx.intAttributeID 
 IN
 (SELECT Distinct([TargetAttributeID]) FROM
 (SELECT Distinct att1.intAttributeID as [TargetAttributeID]
 FROM AST_tblAttributes att1
 INNER JOIN
 AST_lnkProfileDemandAttributes pda
 ON pda.intAttributeID=att1.intAttributeID AND pda.intProfileID = @intProfileID
 union all
 SELECT Distinct ca2.intAttributeID as [TargetAttributeID] FROM
 AST_lnkCapturePolicyAttributes ca2
 INNER JOIN
 AST_lnkEmployeeCapture ec2 ON ec2.intAdminCaptureID = ca2.intAdminCaptureID AND ec2.intTeamID = 57
 WHERE ec2.dteCreatedDate >= @cutoffdate) x)" StatementType="SELECT">
- <StatementSetOptions ANSI_NULLS="false" ANSI_PADDING="false" ANSI_WARNINGS="false" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="false" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="false" />
- <QueryPlan CachedPlanSize="39">
- <MissingIndexes>
- <MissingIndexGroup Impact="1474.55">
- <MissingIndex Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkCapturePolicyAttributes]">
- <ColumnGroup Usage="EQUALITY">
- <Column Name="[intAttributeID]" ColumnId="3" />
- </ColumnGroup>
- <ColumnGroup Usage="INCLUDE">
- <Column Name="[intAdminCaptureID]" ColumnId="1" />
- </ColumnGroup>
- </MissingIndex>
- </MissingIndexGroup>
- </MissingIndexes>
- <RelOp AvgRowSize="84" EstimateCPU="0.0010868" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="172.741" LogicalOp="Left Semi Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.117549">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="intAttributeID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtAttributeName" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtAttributeLabel" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtType" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtEntity" />
- </OutputList>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="intAttributeID" />
- </OuterReferences>
- <RelOp AvgRowSize="84" EstimateCPU="0.000443" EstimateIO="0.00460648" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="260" LogicalOp="Clustered Index Scan" NodeId="1" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00504948">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="intAttributeID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtAttributeName" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtAttributeLabel" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtType" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtEntity" />
- </OutputList>
- <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="intAttributeID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtAttributeName" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtAttributeLabel" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtType" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="txtEntity" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Index="[PK_AST_tblAttributes]" Alias="[attx]" />
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="2E-07" EstimateIO="0" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1" LogicalOp="Concatenation" NodeId="2" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0.111412">
- <OutputList />
- <Concat>
- <DefinedValues />
- <RelOp AvgRowSize="9" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1" LogicalOp="Top" NodeId="4" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.111386">
- <OutputList />
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="9" EstimateCPU="4.68468E-06" EstimateIO="0" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.11136">
- <OutputList />
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="6" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.050481">
- <OutputList />
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues />
- <Object Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Index="[PK_AST_tblAttributes]" Alias="[att1]" />
- <SeekPredicates>
- <SeekPredicate>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[att1]" Column="intAttributeID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_tblAttributes].[intAttributeID] as [attx].[intAttributeID]">
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="intAttributeID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekPredicate>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="15" EstimateCPU="0.000204559" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="259" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="7" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0549782">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkProfileDemandAttributes]" Alias="[pda]" Column="intAttributeID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkProfileDemandAttributes]" Alias="[pda]" Column="intAttributeID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkProfileDemandAttributes]" Index="[PK_AST_lnkProfileDemandAttributes]" Alias="[pda]" />
- <SeekPredicates>
- <SeekPredicate>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkProfileDemandAttributes]" Alias="[pda]" Column="intProfileID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@intProfileID]">
- <Identifier>
- <ColumnReference Column="@intProfileID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekPredicate>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_lnkProfileDemandAttributes].[intAttributeID] as [pda].[intAttributeID]=[CCMI].[dbo].[AST_tblAttributes].[intAttributeID] as [attx].[intAttributeID]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkProfileDemandAttributes]" Alias="[pda]" Column="intAttributeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="intAttributeID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1" LogicalOp="Top" NodeId="11" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.117549">
- <OutputList />
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="9" EstimateCPU="0.000566281" EstimateIO="0" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1" LogicalOp="Filter" NodeId="12" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.117549">
- <OutputList />
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="15" EstimateCPU="0.00493137" EstimateIO="0" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1.84156" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.117549">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="dteCreatedDate" />
- </OutputList>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="txtRACFID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intTeamID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intAdminCaptureID" />
- <ColumnReference Column="Expr1012" />
- </OuterReferences>
- <RelOp AvgRowSize="33" EstimateCPU="0.0864677" EstimateIO="0" EstimateRebinds="246.944" EstimateRewinds="12.0556" EstimateRows="1.84156" LogicalOp="Inner Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.117549">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="txtRACFID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intTeamID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intAdminCaptureID" />
- </OutputList>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkCapturePolicyAttributes]" Alias="[ca2]" Column="intAdminCaptureID" />
- <ColumnReference Column="Expr1011" />
- </OuterReferences>
- <RelOp AvgRowSize="23" EstimateCPU="2.96611" EstimateIO="9.82831" EstimateRebinds="0" EstimateRewinds="259" EstimateRows="32.2904" LogicalOp="Clustered Index Scan" NodeId="17" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.117549">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkCapturePolicyAttributes]" Alias="[ca2]" Column="intAdminCaptureID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkCapturePolicyAttributes]" Alias="[ca2]" Column="intAdminCaptureID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkCapturePolicyAttributes]" Index="[PK_AST_lnkCapturePolicyAttributes]" Alias="[ca2]" />
- <Predicate>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_tblAttributes].[intAttributeID] as [attx].[intAttributeID]=[CCMI].[dbo].[AST_lnkCapturePolicyAttributes].[intAttributeID] as [ca2].[intAttributeID]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_tblAttributes]" Alias="[attx]" Column="intAttributeID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkCapturePolicyAttributes]" Alias="[ca2]" Column="intAttributeID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="33" EstimateCPU="0.000158129" EstimateIO="0.003125" EstimateRebinds="8872.65" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="18" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.117549">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="txtRACFID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intTeamID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intAdminCaptureID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="txtRACFID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intTeamID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intAdminCaptureID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Index="[IDX_intAdminCaptureID]" Alias="[ec2]" />
- <SeekPredicates>
- <SeekPredicate>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intAdminCaptureID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_lnkCapturePolicyAttributes].[intAdminCaptureID] as [ca2].[intAdminCaptureID]">
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkCapturePolicyAttributes]" Alias="[ca2]" Column="intAdminCaptureID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekPredicate>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_lnkEmployeeCapture].[intTeamID] as [ec2].[intTeamID]=(57)">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intTeamID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(57)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="955.771" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="20" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.117549">
- <OutputList>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="dteCreatedDate" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="dteCreatedDate" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Index="[PK_lnkEmployeeCapture]" Alias="[ec2]" TableReferenceId="-1" />
- <SeekPredicates>
- <SeekPredicate>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="txtRACFID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intTeamID" />
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intAdminCaptureID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_lnkEmployeeCapture].[txtRACFID] as [ec2].[txtRACFID]">
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="txtRACFID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_lnkEmployeeCapture].[intTeamID] as [ec2].[intTeamID]">
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intTeamID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_lnkEmployeeCapture].[intAdminCaptureID] as [ec2].[intAdminCaptureID]">
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="intAdminCaptureID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekPredicate>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[CCMI].[dbo].[AST_lnkEmployeeCapture].[dteCreatedDate] as [ec2].[dteCreatedDate]>=[@cutoffdate]">
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[CCMI]" Schema="[dbo]" Table="[AST_lnkEmployeeCapture]" Alias="[ec2]" Column="dteCreatedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@cutoffdate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </Top>
- </RelOp>
- </Concat>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement