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 1

" StatementType="SET ROWCNT" />
- </Statements>
- <Statements>
- <StmtSimple StatementCompId="2" StatementEstRows="1" StatementId="2" StatementOptmLevel="FULL" StatementSubTreeCost="3.55515" 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="0x60FF6FB7A1545392">
- <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="32" CompileTime="26" CompileCPU="26" CompileMemory="648">
- <RelOp AvgRowSize="200" EstimateCPU="0.00140276" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="3.55515">
- <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.039732" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="1" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="3.55515">
- <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="28640.1" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5.90086" LogicalOp="Left Outer Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="3.55515">
- <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>
- <NestedLoops Optimized="false">
- <Predicate>
- <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>
- </Predicate>
- <RelOp AvgRowSize="175" EstimateCPU="0.0082775" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5.90086" LogicalOp="Compute Scalar" NodeId="3" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00332882">
- <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.0912095" EstimateIO="0.674236" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5.90086" LogicalOp="Clustered Index Seek" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00332823" 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>
- </ComputeScalar>
- </RelOp>
- <RelOp AvgRowSize="50" EstimateCPU="0.0149998" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="5.90078" EstimateRows="82775" LogicalOp="Lazy Spool" NodeId="10" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="1.38266">
- <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>
- <Spool>
- <RelOp AvgRowSize="50" EstimateCPU="0.0912095" EstimateIO="1.17794" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="82775" LogicalOp="Clustered Index Seek" NodeId="11" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1.26915" 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>
- </Spool>
- </RelOp>
- </NestedLoops>
- </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>
- </ComputeScalar>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement