Skip to content

Instantly share code, notes, and snippets.

@jjradha
Created October 20, 2016 16:53
Show Gist options
  • Save jjradha/2596ec42bbb4d3d5e8e7618797007e25 to your computer and use it in GitHub Desktop.
Save jjradha/2596ec42bbb4d3d5e8e7618797007e25 to your computer and use it in GitHub Desktop.
warning on the sort operator
<?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.3.1" Build="12.0.5000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="3" StatementEstRows="1.4925" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.0285251" StatementText="SELECT DISTINCT&#xD;&#xA; a.strAccountCode ,&#xD;&#xA; a.strAddressLine6 ,&#xD;&#xA; a.strPostalCode ,&#xD;&#xA; CASE WHEN a.strCountryCode IN ('91','92') THEN 'GB-Int'&#xD;&#xA; ELSE a.strCountryCode&#xD;&#xA; END AS [strCountryCode]&#xD;&#xA; FROM Bocss2.dbo.tblBAccountParticipant AS ap&#xD;&#xA; INNER JOIN Bocss2.dbo.tblBAccountParticipantAddress AS apa ON ap.lngParticipantID = apa.lngParticipantID&#xD;&#xA; AND apa.sintAddressTypeID = 2&#xD;&#xA; INNER JOIN Bocss2.dbo.tblBAccountHolder AS ah ON ap.lngParticipantID = ah.lngParticipantID&#xD;&#xA; INNER JOIN Bocss2.dbo.tblBAddress AS a ON apa.lngAddressID = a.lngAddressID&#xD;&#xA; AND a.blnIsCurrent = 1&#xD;&#xA; INNER JOIN Bocss2.dbo.tblBOrder AS o ON ap.lngParticipantID = o.lngAccountParticipantID&#xD;&#xA; AND o.sdtmOrdCreated &gt;= @FromDate&#xD;&#xA; AND o.sdtmOrdCreated &lt; @ToDate&#xD;&#xA;&#xD;&#xA;OPTION(RECOMPILE)" StatementType="SELECT" QueryHash="0xCD905FEDF5A42CAD" QueryPlanHash="0x45E6B2A5DC0110A4" RetrievedFromCache="false">
<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="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" MemoryGrant="1632" CachedPlanSize="56" CompileTime="44" CompileCPU="44" CompileMemory="1216">
<MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="1632" RequiredMemory="1536" DesiredMemory="1632" RequestedMemory="1632" GrantWaitTime="0" GrantedMemory="1632" MaxUsedMemory="1352" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1677721" EstimatedPagesCached="629145" EstimatedAvailableDegreeOfParallelism="3" />
<RelOp AvgRowSize="60" EstimateCPU="0.000101405" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.4925" LogicalOp="Distinct Sort" NodeId="0" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0285251">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAccountCode" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAddressLine6" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strPostalCode" />
<ColumnReference Column="Expr1006" />
</OutputList>
<Warnings>
<SpillToTempDb SpillLevel="2" />
</Warnings>
<MemoryFractions Input="0.333333" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="15804" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="1785" ActualCPUms="1404" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="125" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAccountCode" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAddressLine6" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strPostalCode" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1006" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="60" EstimateCPU="1.4925E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.4925" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0171625">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAccountCode" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAddressLine6" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strPostalCode" />
<ColumnReference Column="Expr1006" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1006" />
<ScalarOperator ScalarString="CASE WHEN [Bocss2].[dbo].[tblBAddress].[strCountryCode] as [a].[strCountryCode]='92' OR [Bocss2].[dbo].[tblBAddress].[strCountryCode] as [a].[strCountryCode]='91' THEN 'GB-Int' ELSE [Bocss2].[dbo].[tblBAddress].[strCountryCode] as [a].[strCountryCode] END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strCountryCode" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'92'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strCountryCode" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'91'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'GB-Int'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strCountryCode" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="57" EstimateCPU="6.23864E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.4925" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0171623">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAccountCode" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAddressLine6" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strPostalCode" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strCountryCode" />
</OutputList>
<MemoryFractions Input="0" Output="0.333333" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="16353" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="1575" ActualCPUms="1275" />
</RunTimeInformation>
<NestedLoops Optimized="true">
<OuterReferences>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipantAddress]" Alias="[apa]" Column="lngAddressID" />
</OuterReferences>
<RelOp AvgRowSize="11" EstimateCPU="6.23864E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.4925" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0131475">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipantAddress]" Alias="[apa]" Column="lngAddressID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="53399" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="837" ActualCPUms="696" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</OuterReferences>
<RelOp AvgRowSize="11" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00985766">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</OutputList>
<MemoryFractions Input="0" Output="0.333333" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="16353" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="490" ActualCPUms="418" />
</RunTimeInformation>
<NestedLoops Optimized="true">
<OuterReferences>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</OuterReferences>
<RelOp AvgRowSize="11" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657038">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="16353" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="221" ActualCPUms="209" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</OuterReferences>
<RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="8" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="45193800">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="16355" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="22" ActualCPUms="18" ActualScans="1" ActualLogicalReads="715" 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>
<DefinedValue>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</DefinedValue>
</DefinedValues>
<Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Index="[IX_tblBOrder_sdtmOrdCreated_INCL]" Alias="[o]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<StartRange ScanType="GE">
<RangeColumns>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'2016-10-19 11:00:00.000'">
<Const ConstValue="'2016-10-19 11:00:00.000'" />
</ScalarOperator>
</RangeExpressions>
</StartRange>
<EndRange ScanType="LT">
<RangeColumns>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="sdtmOrdCreated" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="'2016-10-20 12:00:00.000'">
<Const ConstValue="'2016-10-20 12:00:00.000'" />
</ScalarOperator>
</RangeExpressions>
</EndRange>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.0001581" 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="9697640">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="16353" ActualEndOfScans="2" ActualExecutions="16355" ActualElapsedms="162" ActualCPUms="154" ActualScans="0" ActualLogicalReads="49065" 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="[Bocss2]" Schema="[dbo]" Table="[tblBAccountHolder]" Index="[PK_tblAccountHolder]" Alias="[ah]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountHolder]" Alias="[ah]" Column="lngParticipantID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[lngAccountParticipantID] as [o].[lngAccountParticipantID]">
<Identifier>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="10" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="15004400">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="16353" ActualEndOfScans="0" ActualExecutions="16353" ActualElapsedms="141" ActualCPUms="135" ActualScans="0" ActualLogicalReads="49059" 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="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Index="[PK_tblBAccountParticipants]" Alias="[ap]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipant]" Alias="[ap]" Column="lngParticipantID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[lngAccountParticipantID] as [o].[lngAccountParticipantID]">
<Identifier>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="11" EstimateCPU="0.000158642" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1.4925" LogicalOp="Index Seek" NodeId="11" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00328364" TableCardinality="22329600">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipantAddress]" Alias="[apa]" Column="lngAddressID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="53399" ActualEndOfScans="16353" ActualExecutions="16353" ActualElapsedms="283" ActualCPUms="226" ActualScans="16353" ActualLogicalReads="49226" 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>
<DefinedValue>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipantAddress]" Alias="[apa]" Column="lngAddressID" />
</DefinedValue>
</DefinedValues>
<Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipantAddress]" Index="[IDXF_tblBAccountParticipantAddress_lngParticipantID]" Filtered="true" Alias="[apa]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipantAddress]" Alias="[apa]" Column="lngParticipantID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Bocss2].[dbo].[tblBOrder].[lngAccountParticipantID] as [o].[lngAccountParticipantID]">
<Identifier>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBOrder]" Alias="[o]" Column="lngAccountParticipantID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp AvgRowSize="57" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0.492498" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="12" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00400853" TableCardinality="22085100">
<OutputList>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAccountCode" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAddressLine6" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strPostalCode" />
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strCountryCode" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="16353" ActualEndOfScans="37046" ActualExecutions="53399" ActualElapsedms="473" ActualCPUms="407" ActualScans="0" ActualLogicalReads="160197" 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>
<DefinedValue>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAccountCode" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strAddressLine6" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strPostalCode" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="strCountryCode" />
</DefinedValue>
</DefinedValues>
<Object Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Index="[IDXF_tblBAddress_lngAddressID__INC]" Filtered="true" Alias="[a]" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAddress]" Alias="[a]" Column="lngAddressID" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[Bocss2].[dbo].[tblBAccountParticipantAddress].[lngAddressID] as [apa].[lngAddressID]">
<Identifier>
<ColumnReference Database="[Bocss2]" Schema="[dbo]" Table="[tblBAccountParticipantAddress]" Alias="[apa]" Column="lngAddressID" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
</Sort>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment