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.1" Build="10.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementId="1" StatementText="SET ROWCOUNT 2

" StatementType="SET ROWCNT" />
- </Statements>
- <Statements>
- <StmtSimple StatementCompId="2" StatementEstRows="2" StatementId="2" StatementOptmLevel="FULL" StatementSubTreeCost="2.28433" StatementText="
SELECT 
 A.REFERENCE_DATE AS REFERENCE_DATE
 ,A.MIS_BANK_ID AS BANK_ID
 ,'Unknown credit line' AS QUERY_LOG
 ,'STG_MIS_CREDIT_LINES_VALUE' AS [TABLE]
 ,'MIS_CREDIT_LINE_BRANCH_ID - MIS_CREDIT_LINE_ID' AS FIELD
 ,( 'MIS_CREDIT_LINE_BRANCH_ID: ' + A.MIS_CREDIT_LINE_BRANCH_ID + ' # MIS_CREDIT_LINE_ID: ' + A.MIS_CREDIT_LINE_ID ) AS [KEY]
 ,( A.MIS_CREDIT_LINE_BRANCH_ID + ' - ' + A.MIS_CREDIT_LINE_ID ) AS RESULT_1
 ,NULL AS RESULT_2
 ,NULL AS OUTSTANDING
FROM 
 STG_MIS_CREDIT_LINES_VALUE A
LEFT JOIN 
 STG_MIS_REG_CREDIT_LINES B ON A.REFERENCE_DATE = B.REFERENCE_DATE
 AND A.MIS_BANK_ID = B.MIS_BANK_ID
 AND A.MIS_CREDIT_LINE_BRANCH_ID = B.MIS_CREDIT_LINE_BRANCH_ID
 AND A.MIS_CREDIT_LINE_ID = B.MIS_CREDIT_LINE_ID
WHERE 
 B.MIS_CREDIT_LINE_ID IS NULL
 AND A.REFERENCE_DATE = '20131231'" StatementType="SELECT" QueryHash="0x09CCC1CC1649AD7E" QueryPlanHash="0x7C2C04711299BD74">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan CachedPlanSize="64" CompileTime="30" CompileCPU="30" CompileMemory="688">
- <RelOp AvgRowSize="200" EstimateCPU="0.00140276" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="2.28433">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Column="Expr1004" />
- <ColumnReference Column="Expr1005" />
- <ColumnReference Column="Expr1006" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1004" />
- <ScalarOperator ScalarString="'Unknown credit line'">
- <Const ConstValue="'Unknown credit line'" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1005" />
- <ScalarOperator ScalarString="'STG_MIS_CREDIT_LINES_VALUE'">
- <Const ConstValue="'STG_MIS_CREDIT_LINES_VALUE'" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1006" />
- <ScalarOperator ScalarString="'MIS_CREDIT_LINE_BRANCH_ID - MIS_CREDIT_LINE_ID'">
- <Const ConstValue="'MIS_CREDIT_LINE_BRANCH_ID - MIS_CREDIT_LINE_ID'" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1009" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1010" />
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="140" EstimateCPU="0.0285147" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="2.28433">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- </OutputList>
- <Parallelism>
- <RelOp AvgRowSize="140" EstimateCPU="0.0079464" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Filter" NodeId="2" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="2.25582">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- </OutputList>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="167" EstimateCPU="1.05681" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="11.8017" LogicalOp="Right Outer Join" NodeId="3" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="2.25582">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- </OutputList>
- <MemoryFractions Input="1" Output="1" />
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_CREDIT_LINES_VALUE].[MIS_BANK_ID] as [A].[MIS_BANK_ID]=[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_REG_CREDIT_LINES].[MIS_BANK_ID] as [B].[MIS_BANK_ID] AND [EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_CREDIT_LINES_VALUE].[MIS_CREDIT_LINE_BRANCH_ID] as [A].[MIS_CREDIT_LINE_BRANCH_ID]=[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_REG_CREDIT_LINES].[MIS_CREDIT_LINE_BRANCH_ID] as [B].[MIS_CREDIT_LINE_BRANCH_ID] AND [EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_CREDIT_LINES_VALUE].[MIS_CREDIT_LINE_ID] as [A].[MIS_CREDIT_LINE_ID]=[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_REG_CREDIT_LINES].[MIS_CREDIT_LINE_ID] as [B].[MIS_CREDIT_LINE_ID]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_BANK_ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="50" EstimateCPU="0.169785" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="82775" LogicalOp="Repartition Streams" NodeId="4" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1.36597">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- </OutputList>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- </PartitionColumns>
- <RelOp AvgRowSize="50" EstimateCPU="0.0182419" EstimateIO="1.17794" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="82775" LogicalOp="Clustered Index Seek" NodeId="5" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1.19618" TableCardinality="82775">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_BANK_ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Index="[PK_STG_MIS_REG_CREDIT_LINES_1038732168]" Alias="[B]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="REFERENCE_DATE" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="'2013-12-31 00:00:00.000'">
- <Const ConstValue="'2013-12-31 00:00:00.000'" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- <RelOp AvgRowSize="175" EstimateCPU="0.0016555" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="11.8017" LogicalOp="Compute Scalar" NodeId="6" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0317771">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- <ColumnReference Column="Expr1007" />
- <ColumnReference Column="Expr1008" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1007" />
- <ScalarOperator ScalarString="((N'MIS_CREDIT_LINE_BRANCH_ID: '+[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_CREDIT_LINES_VALUE].[MIS_CREDIT_LINE_BRANCH_ID] as [A].[MIS_CREDIT_LINE_BRANCH_ID])+N' # MIS_CREDIT_LINE_ID: ')+[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_CREDIT_LINES_VALUE].[MIS_CREDIT_LINE_ID] as [A].[MIS_CREDIT_LINE_ID]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="N'MIS_CREDIT_LINE_BRANCH_ID: '" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N' # MIS_CREDIT_LINE_ID: '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1008" />
- <ScalarOperator ScalarString="([EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_CREDIT_LINES_VALUE].[MIS_CREDIT_LINE_BRANCH_ID] as [A].[MIS_CREDIT_LINE_BRANCH_ID]+N' - ')+[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_CREDIT_LINES_VALUE].[MIS_CREDIT_LINE_ID] as [A].[MIS_CREDIT_LINE_ID]">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N' - '" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="58" EstimateCPU="0.0285302" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="11.8017" LogicalOp="Repartition Streams" NodeId="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317768">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </OutputList>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </PartitionColumns>
- <RelOp AvgRowSize="58" EstimateCPU="0.0182419" EstimateIO="0.674236" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="11.8017" LogicalOp="Clustered Index Seek" NodeId="8" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00324657" TableCardinality="82775">
- <OutputList>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_BANK_ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_BRANCH_ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="MIS_CREDIT_LINE_ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Index="[PK_STG_MIS_CREDIT_LINES_VALUE_641814275]" Alias="[A]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_CREDIT_LINES_VALUE]" Alias="[A]" Column="REFERENCE_DATE" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="'2013-12-31 00:00:00.000'">
- <Const ConstValue="'2013-12-31 00:00:00.000'" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Hash>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[EAGLE_BIH_MIS_MAPPER].[dbo].[STG_MIS_REG_CREDIT_LINES].[MIS_CREDIT_LINE_ID] as [B].[MIS_CREDIT_LINE_ID] IS NULL">
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[EAGLE_BIH_MIS_MAPPER]" Schema="[dbo]" Table="[STG_MIS_REG_CREDIT_LINES]" Alias="[B]" Column="MIS_CREDIT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </Parallelism>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement