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.4001.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="1.15102" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="130" StatementSubTreeCost="209.042" StatementText="SELECT TOP 10000 
OBJECT_TYPE,
SEQ_NO,
O.AGR_LINE_NO,
SHORT_DESC,
C02,
C03,
C04,
C05,
C07,
C10,
C52,
N05,
N04,
N02,
N19,
N01,
X.[Description] AS CarConcept,
O.[Timestamp] AS OBJ_TIMESTAMP,
O.Record_Timestamp AS OBJ_RECORD_TIMESTAMP,
X.RECORD_TIMESTAMP AS X_RECORD_TIMESTAMP

 FROM [Archive].[TIA_TIA_OBJECT] O

 INNER JOIN [Archive].[TIA_TIA_AGREEMENT_LINE] A 
 ON A.AGR_LINE_NO = O.Agr_Line_No

 INNER JOIN [Archive].[TIA_TIA_PRODUCT_LINE] PL 
 ON PL.PRODUCT_LINE_ID = A.PRODUCT_LINE_ID AND PL.PRODUCT_LINE_VER_NO = A.PRODUCT_LINE_VER_NO

 INNER JOIN [Archive].[TIA_TIA_TARIFF_STRUCTURE] TS 
 ON PL.TARIFF_TYPE_LIST_VER = TS.[VERSION] AND PL.PRODUCT_LINE_ID = TS.PRODUCT_LINE_ID

 INNER JOIN [Archive].[TIA_TIA_TARIFF_CODES] TC 
 ON TC.PRODUCT_LINE_ID = PL.PRODUCT_LINE_ID AND TC.[TYPE] = TS.[TYPE] AND TC.[VERSION] = TS.TYPE_VERSION 

 INNER JOIN [Archive].[TIA_TIA_XLA_PE_REFERENCE] X
 ON TC.[TYPE] = X.Table_Name AND PL.PRODUCT_LINE_ID = X.ID AND TC.[VERSION] = X.[VERSION] AND TC.CODE = X.[CODE]
 
 WHERE O.OBJECT_TYPE = 'BIO01'
 
 AND 
 TC.[TYPE] = 
 CASE WHEN O.C52 IS NOT NULL 
 THEN 'XTARIFTYPE'
 ELSE 'ART'
 END
 
 AND X.[Language] = 'DK'
 
 AND 
 X.Code =
 CASE WHEN O.C52 IS NOT NULL 
 THEN O.C52
 ELSE O.C02
 END

 AND O.Meta_IsCurrent = 1 
 AND A.Meta_IsCurrent = 1
 AND PL.Meta_IsCurrent = 1
 AND TS.Meta_IsCurrent = 1
 AND TC.Meta_IsCurrent = 1
 AND X.Meta_IsCurrent = 1" StatementType="SELECT" QueryHash="0x9AB9556A6FF14F66" QueryPlanHash="0x4895E04D541DAD52" RetrievedFromCache="true">
- <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="44512" CachedPlanSize="192" CompileTime="437" CompileCPU="437" CompileMemory="6328">
- <MemoryGrantInfo SerialRequiredMemory="2048" SerialDesiredMemory="44512" RequiredMemory="2048" DesiredMemory="44512" RequestedMemory="44512" GrantWaitTime="0" GrantedMemory="44512" MaxUsedMemory="3152" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="104857" EstimatedPagesCached="13107" EstimatedAvailableDegreeOfParallelism="2" />
- <RelOp AvgRowSize="32124" EstimateCPU="1.15102E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.15102" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="209.042">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Seq_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="OBJECT_TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="SHORT_DESC" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C03" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C07" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C10" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N01" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N19" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Record_Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Description" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="RECORD_TIMESTAMP" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="10000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="874" ActualCPUms="830" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(10000)">
- <Const ConstValue="(10000)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="32124" EstimateCPU="0.00500759" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.15102" LogicalOp="Inner Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="209.042">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Seq_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="OBJECT_TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="SHORT_DESC" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C03" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C07" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C10" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N01" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N19" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Record_Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Description" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="RECORD_TIMESTAMP" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="10000" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="873" ActualCPUms="829" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="ID" />
- </OuterReferences>
- <RelOp AvgRowSize="32138" EstimateCPU="2.31853" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="13.8102" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="205.121">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Seq_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="OBJECT_TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="SHORT_DESC" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C03" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C07" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C10" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N01" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N19" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Record_Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Description" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="RECORD_TIMESTAMP" />
- </OutputList>
- <MemoryFractions Input="0.983986" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="155757" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="438" ActualCPUms="394" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Table_Name" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Code" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Column="Expr1010" />
- <ColumnReference Column="Expr1009" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_XLA_PE_REFERENCE].[Table_Name] as [X].[Table_Name]=[Expr1010] AND [Datahub].[Archive].[TIA_TIA_XLA_PE_REFERENCE].[Code] as [X].[Code]=[Expr1009]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Table_Name" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1010" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Code" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1009" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="4060" EstimateCPU="0.00494692" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="402.123" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.938131">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Table_Name" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Code" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Description" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="RECORD_TIMESTAMP" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="18975" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="296" ActualCPUms="251" />
- </RunTimeInformation>
- <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="VERSION" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="CODE" />
- <ColumnReference Column="Expr1012" />
- </OuterReferences>
- <RelOp AvgRowSize="74" EstimateCPU="0.194842" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1183.47" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.632837">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="VERSION" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="CODE" />
- </OutputList>
- <MemoryFractions Input="0.867347" Output="0.0160136" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="46863" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="33" ActualCPUms="33" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE_VERSION" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="VERSION" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_TARIFF_STRUCTURE].[PRODUCT_LINE_ID] as [TS].[PRODUCT_LINE_ID]=[Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[PRODUCT_LINE_ID] as [TC].[PRODUCT_LINE_ID] AND [Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[TYPE] as [TC].[TYPE]=[Datahub].[Archive].[TIA_TIA_TARIFF_STRUCTURE].[TYPE] as [TS].[TYPE] AND [Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[VERSION] as [TC].[VERSION]=[Datahub].[Archive].[TIA_TIA_TARIFF_STRUCTURE].[TYPE_VERSION] as [TS].[TYPE_VERSION]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="PRODUCT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="PRODUCT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="TYPE" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="VERSION" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE_VERSION" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="53" EstimateCPU="0.0389689" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="903.144" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.096125">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE_VERSION" />
- </OutputList>
- <MemoryFractions Input="1" Output="0.132653" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="3198" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="2" ActualCPUms="2" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="TARIFF_TYPE_LIST_VER" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="VERSION" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_PRODUCT_LINE].[PRODUCT_LINE_ID] as [PL].[PRODUCT_LINE_ID]=[Datahub].[Archive].[TIA_TIA_TARIFF_STRUCTURE].[PRODUCT_LINE_ID] as [TS].[PRODUCT_LINE_ID] AND [Datahub].[Archive].[TIA_TIA_PRODUCT_LINE].[TARIFF_TYPE_LIST_VER] as [PL].[TARIFF_TYPE_LIST_VER]=[Datahub].[Archive].[TIA_TIA_TARIFF_STRUCTURE].[VERSION] as [TS].[VERSION]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="PRODUCT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="TARIFF_TYPE_LIST_VER" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="VERSION" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="29" EstimateCPU="0.0002989" EstimateIO="0.00534722" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="129" LogicalOp="Clustered Index Scan" NodeId="7" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00564612" TableCardinality="129">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="TARIFF_TYPE_LIST_VER" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="129" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="TARIFF_TYPE_LIST_VER" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Index="[ClusteredIndex-20170808-124641]" Alias="[PL]" IndexKind="Clustered" Storage="RowStore" />
- <Predicate>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_PRODUCT_LINE].[Meta_IsCurrent] as [PL].[Meta_IsCurrent]=(1)">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="Meta_IsCurrent" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="45" EstimateCPU="0.0027431" EstimateIO="0.0475694" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2351" LogicalOp="Clustered Index Scan" NodeId="8" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0503125" TableCardinality="2351">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="VERSION" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE_VERSION" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="2351" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualScans="1" ActualLogicalReads="63" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="PRODUCT_LINE_ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="VERSION" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="TYPE_VERSION" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Index="[PK_ARCH_TIA_TIA_TARIFF_STRUCUTRE]" Alias="[TS]" IndexKind="Clustered" Storage="RowStore" />
- <Predicate>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_TARIFF_STRUCTURE].[Meta_IsCurrent] as [TS].[Meta_IsCurrent]=(1)">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_STRUCTURE]" Alias="[TS]" Column="Meta_IsCurrent" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Hash>
- </RelOp>
- <RelOp AvgRowSize="48" EstimateCPU="0.0187635" EstimateIO="0.314977" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="16915" LogicalOp="Clustered Index Scan" NodeId="9" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.33374" TableCardinality="16915">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="PRODUCT_LINE_ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="VERSION" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="CODE" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="16915" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="5" ActualCPUms="5" ActualScans="1" ActualLogicalReads="424" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="PRODUCT_LINE_ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="TYPE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="VERSION" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="CODE" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Index="[PK_ARCH_TIA_TIA_TARIFF_CODES]" Alias="[TC]" IndexKind="Clustered" Storage="RowStore" />
- <Predicate>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[Meta_IsCurrent] as [TC].[Meta_IsCurrent]=(1)">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="Meta_IsCurrent" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Hash>
- </RelOp>
- <RelOp AvgRowSize="4064" EstimateCPU="0.000158157" EstimateIO="0.003125" EstimateRebinds="1182.33" EstimateRewinds="0.138687" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="10" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.298505" TableCardinality="17339">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Table_Name" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Code" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="ID" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Description" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="RECORD_TIMESTAMP" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="18975" Batches="0" ActualEndOfScans="46863" ActualExecutions="46863" ActualExecutionMode="Row" ActualElapsedms="239" ActualCPUms="203" ActualScans="46863" ActualLogicalReads="145166" ActualPhysicalReads="44" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Table_Name" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Code" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="ID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Description" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="RECORD_TIMESTAMP" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Index="[PK_TIA_XLA_PE_REFERENCE]" Alias="[X]" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Table_Name" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Code" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[TYPE] as [TC].[TYPE]">
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="TYPE" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[CODE] as [TC].[CODE]">
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="CODE" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[VERSION] as [TC].[VERSION]=[Datahub].[Archive].[TIA_TIA_XLA_PE_REFERENCE].[VERSION] as [X].[VERSION] AND [Datahub].[Archive].[TIA_TIA_XLA_PE_REFERENCE].[Meta_IsCurrent] as [X].[Meta_IsCurrent]=(1) AND [Datahub].[Archive].[TIA_TIA_XLA_PE_REFERENCE].[ID] as [X].[ID]=[Datahub].[Archive].[TIA_TIA_TARIFF_CODES].[PRODUCT_LINE_ID] as [TC].[PRODUCT_LINE_ID] AND [Datahub].[Archive].[TIA_TIA_XLA_PE_REFERENCE].[Language] as [X].[Language]=N'DK'">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="VERSION" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="VERSION" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Meta_IsCurrent" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_TARIFF_CODES]" Alias="[TC]" Column="PRODUCT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="Language" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'DK'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="32129" EstimateCPU="0.467924" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="179971" LogicalOp="Compute Scalar" NodeId="11" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="197.747">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Seq_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="OBJECT_TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="SHORT_DESC" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C03" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C07" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C10" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N01" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N19" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Record_Timestamp" />
- <ColumnReference Column="Expr1009" />
- <ColumnReference Column="Expr1010" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1009" />
- <ScalarOperator ScalarString="CASE WHEN [Datahub].[Archive].[TIA_TIA_OBJECT].[C52] as [O].[C52] IS NOT NULL THEN [Datahub].[Archive].[TIA_TIA_OBJECT].[C52] as [O].[C52] ELSE [Datahub].[Archive].[TIA_TIA_OBJECT].[C02] as [O].[C02] END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- </Identifier>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C02" />
- </Identifier>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1010" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),CASE WHEN [Datahub].[Archive].[TIA_TIA_OBJECT].[C52] as [O].[C52] IS NOT NULL THEN 'XTARIFTYPE' ELSE 'ART' END,0)">
- <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="'XTARIFTYPE'" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="'ART'" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="28115" EstimateCPU="5.14733" EstimateIO="192.131" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="179971" LogicalOp="Table Scan" NodeId="12" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="197.279" TableCardinality="4679240">
- <OutputList>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Seq_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="OBJECT_TYPE" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="SHORT_DESC" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C03" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C07" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C10" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N01" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N02" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N04" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N05" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N19" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Timestamp" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Record_Timestamp" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="10010" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" ActualElapsedms="49" ActualCPUms="49" ActualScans="1" ActualLogicalReads="7117" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Seq_No" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="OBJECT_TYPE" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="SHORT_DESC" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C02" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C03" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C04" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C05" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C07" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C10" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="C52" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N01" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N02" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N04" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N05" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="N19" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Timestamp" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Record_Timestamp" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" IndexKind="Heap" Storage="RowStore" />
- <Predicate>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_OBJECT].[Meta_IsCurrent] as [O].[Meta_IsCurrent]=(1) AND [Datahub].[Archive].[TIA_TIA_OBJECT].[OBJECT_TYPE] as [O].[OBJECT_TYPE]=N'BIO01'">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Meta_IsCurrent" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="OBJECT_TYPE" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'BIO01'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </TableScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Hash>
- </RelOp>
- <RelOp AvgRowSize="24" EstimateCPU="0.000158102" EstimateIO="0.003125" EstimateRebinds="12.8102" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0451485" TableCardinality="4671660">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="10000" Batches="0" ActualEndOfScans="155756" ActualExecutions="155757" ActualExecutionMode="Row" ActualElapsedms="417" ActualCPUms="417" ActualScans="155757" ActualLogicalReads="477198" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues />
- <Object Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_AGREEMENT_LINE]" Index="[ClusteredIndex-20170808-124714]" Alias="[A]" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_AGREEMENT_LINE]" Alias="[A]" Column="AGR_LINE_NO" />
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_AGREEMENT_LINE]" Alias="[A]" Column="Meta_IsCurrent" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_OBJECT].[Agr_Line_No] as [O].[Agr_Line_No]">
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_OBJECT]" Alias="[O]" Column="Agr_Line_No" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[Datahub].[Archive].[TIA_TIA_PRODUCT_LINE].[PRODUCT_LINE_VER_NO] as [PL].[PRODUCT_LINE_VER_NO]=[Datahub].[Archive].[TIA_TIA_AGREEMENT_LINE].[PRODUCT_LINE_VER_NO] as [A].[PRODUCT_LINE_VER_NO] AND [Datahub].[Archive].[TIA_TIA_AGREEMENT_LINE].[PRODUCT_LINE_ID] as [A].[PRODUCT_LINE_ID]=[Datahub].[Archive].[TIA_TIA_XLA_PE_REFERENCE].[ID] as [X].[ID]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_PRODUCT_LINE]" Alias="[PL]" Column="PRODUCT_LINE_VER_NO" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_AGREEMENT_LINE]" Alias="[A]" Column="PRODUCT_LINE_VER_NO" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_AGREEMENT_LINE]" Alias="[A]" Column="PRODUCT_LINE_ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Datahub]" Schema="[Archive]" Table="[TIA_TIA_XLA_PE_REFERENCE]" Alias="[X]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Top>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement