Created
August 12, 2016 10:14
-
-
Save jjradha/d11f2184e8afe496f84af77b1f77f0be to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="10" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.00657344" StatementText="SELECT TOP 1 ISNULL(pst.TaxCode, '') as TaxCode
 , ISNULL(pst.TaxRate, 0) as TaxRate
FROM dbo.[ProductShipTax] pst
WHERE EXISTS (

 SELECT TaxRegionId
 FROM dbo.[ShipTaxAddress]
 WHERE [CountryCode] = @countryCode
 AND [AddressFormatID] = @addressFormatID

 AND ([MatchAddressLine1] = @AddressLine1 OR ([MatchAddressLine1] IS NULL AND @AddressLine1 IS NULL) )
 AND ([MatchAddressLine2] = @AddressLine2 OR ([MatchAddressLine2] IS NULL AND @AddressLine2 IS NULL) )
 AND ([MatchAddressLine3] = @AddressLine3 OR ([MatchAddressLine3] IS NULL AND @AddressLine3 IS NULL) )
 AND ([MatchAddressLine4] = @AddressLine4 OR ([MatchAddressLine4] IS NULL AND @AddressLine4 IS NULL) )
 AND ([MatchAddressLine5] = @AddressLine5 OR ([MatchAddressLine5] IS NULL AND @AddressLine5 IS NULL) )
 AND ([MatchAddressLine6] = @AddressLine6 OR ([MatchAddressLine6] IS NULL AND @AddressLine6 IS NULL) )

 AND (@postalcode = [MatchPostalCode] OR ([MatchPostalCode] IS NULL AND @postalcode IS NULL) )
 AND TaxRegionId = pst.TaxRegionId 


)
AND pst.[ItemNo] = @itemNo
AND @calculateDate BETWEEN pst.[DateFrom] AND pst.[DateTo]" StatementType="SELECT" QueryHash="0xC50B06E08A83A95A" QueryPlanHash="0x3CE584F78105D09D" 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" CachedPlanSize="48" CompileTime="5" CompileCPU="5" CompileMemory="824"> | |
| <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" /> | |
| <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="417953" EstimatedPagesCached="104488" EstimatedAvailableDegreeOfParallelism="2" /> | |
| <RelOp AvgRowSize="30" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00657344"> | |
| <OutputList> | |
| <ColumnReference Column="Expr1004" /> | |
| <ColumnReference Column="Expr1005" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <Top RowCount="false" IsPercent="false" WithTies="false"> | |
| <TopExpression> | |
| <ScalarOperator ScalarString="(1)"> | |
| <Const ConstValue="(1)" /> | |
| </ScalarOperator> | |
| </TopExpression> | |
| <RelOp AvgRowSize="30" EstimateCPU="4.22593E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657334"> | |
| <OutputList> | |
| <ColumnReference Column="Expr1004" /> | |
| <ColumnReference Column="Expr1005" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="false"> | |
| <Predicate> | |
| <ScalarOperator ScalarString="[US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[TaxRegionId]=[US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[TaxRegionId] as [pst].[TaxRegionId]"> | |
| <Compare CompareOp="EQ"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="TaxRegionId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Predicate> | |
| <RelOp AvgRowSize="34" EstimateCPU="1.01099E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00328368"> | |
| <OutputList> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" /> | |
| <ColumnReference Column="Expr1004" /> | |
| <ColumnReference Column="Expr1005" /> | |
| </OutputList> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1004" /> | |
| <ScalarOperator ScalarString="isnull([US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[TaxCode] as [pst].[TaxCode],'')"> | |
| <Intrinsic FunctionName="isnull"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="''" /> | |
| </ScalarOperator> | |
| </Intrinsic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Column="Expr1005" /> | |
| <ScalarOperator ScalarString="[US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[TaxRate] as [pst].[TaxRate]"> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="38" EstimateCPU="0.000158112" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="60057"> | |
| <OutputList> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" /> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" /> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <NestedLoops Optimized="false"> | |
| <OuterReferences> | |
| <ColumnReference Column="Expr1007" /> | |
| <ColumnReference Column="Expr1008" /> | |
| <ColumnReference Column="Expr1006" /> | |
| </OuterReferences> | |
| <RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0"> | |
| <OutputList> | |
| <ColumnReference Column="Expr1007" /> | |
| <ColumnReference Column="Expr1008" /> | |
| <ColumnReference Column="Expr1006" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <ComputeScalar> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ValueVector> | |
| <ColumnReference Column="Expr1007" /> | |
| <ColumnReference Column="Expr1008" /> | |
| <ColumnReference Column="Expr1006" /> | |
| </ValueVector> | |
| <ScalarOperator ScalarString="GetRangeWithMismatchedTypes(NULL,[@calculateDate],(42))"> | |
| <Intrinsic FunctionName="GetRangeWithMismatchedTypes"> | |
| <ScalarOperator> | |
| <Const ConstValue="NULL" /> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@calculateDate" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Const ConstValue="(42)" /> | |
| </ScalarOperator> | |
| </Intrinsic> | |
| </ScalarOperator> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <RelOp AvgRowSize="0" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="5" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0"> | |
| <OutputList /> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <ConstantScan /> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| <RelOp AvgRowSize="38" EstimateCPU="0.000158112" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="9" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="60057"> | |
| <OutputList> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" /> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" /> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" /> | |
| </DefinedValue> | |
| <DefinedValue> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Index="[IX_ProductShipTax_ITemNo_DateFrom_DateTo]" Alias="[pst]" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="ItemNo" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[@itemNo]"> | |
| <Identifier> | |
| <ColumnReference Column="@itemNo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| <StartRange ScanType="GT"> | |
| <RangeColumns> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="DateFrom" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Expr1007]"> | |
| <Identifier> | |
| <ColumnReference Column="Expr1007" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </StartRange> | |
| <EndRange ScanType="LT"> | |
| <RangeColumns> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="DateFrom" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[Expr1008]"> | |
| <Identifier> | |
| <ColumnReference Column="Expr1008" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </EndRange> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| <Predicate> | |
| <ScalarOperator ScalarString="[@calculateDate]<=[US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[DateTo] as [pst].[DateTo]"> | |
| <Compare CompareOp="LE"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@calculateDate" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="DateTo" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Predicate> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </ComputeScalar> | |
| </RelOp> | |
| <RelOp AvgRowSize="277" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="15" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="185"> | |
| <OutputList> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="TaxRegionId" /> | |
| </OutputList> | |
| <RunTimeInformation> | |
| <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" /> | |
| </RunTimeInformation> | |
| <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore"> | |
| <DefinedValues> | |
| <DefinedValue> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="TaxRegionId" /> | |
| </DefinedValue> | |
| </DefinedValues> | |
| <Object Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Index="[IDX_ShipTaxAddress_ShipTaxAddress]" IndexKind="NonClustered" Storage="RowStore" /> | |
| <SeekPredicates> | |
| <SeekPredicateNew> | |
| <SeekKeys> | |
| <Prefix ScanType="EQ"> | |
| <RangeColumns> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="CountryCode" /> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="AddressFormatId" /> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchPostalCode" /> | |
| </RangeColumns> | |
| <RangeExpressions> | |
| <ScalarOperator ScalarString="[@countryCode]"> | |
| <Identifier> | |
| <ColumnReference Column="@countryCode" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[@addressFormatID]"> | |
| <Identifier> | |
| <ColumnReference Column="@addressFormatID" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator ScalarString="[@postalCode]"> | |
| <Identifier> | |
| <ColumnReference Column="@postalCode" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </RangeExpressions> | |
| </Prefix> | |
| </SeekKeys> | |
| </SeekPredicateNew> | |
| </SeekPredicates> | |
| <Predicate> | |
| <ScalarOperator ScalarString="[US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine1] = [@addressLine1] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine2] = [@addressLine2] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine3] = [@addressLine3] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine4] = [@addressLine4] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine5] = [@addressLine5] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine6] = [@addressLine6]"> | |
| <Logical Operation="AND"> | |
| <ScalarOperator> | |
| <Compare CompareOp="IS"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine1" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@addressLine1" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Compare CompareOp="IS"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine2" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@addressLine2" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Compare CompareOp="IS"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine3" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@addressLine3" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Compare CompareOp="IS"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine4" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@addressLine4" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Compare CompareOp="IS"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine5" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@addressLine5" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Compare CompareOp="IS"> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine6" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| <ScalarOperator> | |
| <Identifier> | |
| <ColumnReference Column="@addressLine6" /> | |
| </Identifier> | |
| </ScalarOperator> | |
| </Compare> | |
| </ScalarOperator> | |
| </Logical> | |
| </ScalarOperator> | |
| </Predicate> | |
| </IndexScan> | |
| </RelOp> | |
| </NestedLoops> | |
| </RelOp> | |
| </Top> | |
| </RelOp> | |
| <ParameterList> | |
| <ColumnReference Column="@calculateDate" ParameterCompiledValue="'2016-08-08 13:01:46.760'" ParameterRuntimeValue="'2016-08-08 13:01:46.760'" /> | |
| <ColumnReference Column="@itemNo" ParameterCompiledValue="'31997299'" ParameterRuntimeValue="'31997299'" /> | |
| <ColumnReference Column="@postalCode" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" /> | |
| <ColumnReference Column="@addressLine6" ParameterCompiledValue="N'FL'" ParameterRuntimeValue="N'FL'" /> | |
| <ColumnReference Column="@addressLine5" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" /> | |
| <ColumnReference Column="@addressLine4" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" /> | |
| <ColumnReference Column="@addressLine3" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" /> | |
| <ColumnReference Column="@addressLine2" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" /> | |
| <ColumnReference Column="@addressLine1" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" /> | |
| <ColumnReference Column="@addressFormatID" ParameterCompiledValue="(2)" ParameterRuntimeValue="(2)" /> | |
| <ColumnReference Column="@countryCode" ParameterCompiledValue="'US'" ParameterRuntimeValue="'US'" /> | |
| </ParameterList> | |
| </QueryPlan> | |
| </StmtSimple> | |
| </Statements> | |
| </Batch> | |
| </BatchSequence> | |
| </ShowPlanXML> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment