Created
October 20, 2016 16:53
-
-
Save jjradha/2596ec42bbb4d3d5e8e7618797007e25 to your computer and use it in GitHub Desktop.
warning on the sort operator
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.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
 a.strAccountCode ,
 a.strAddressLine6 ,
 a.strPostalCode ,
 CASE WHEN a.strCountryCode IN ('91','92') THEN 'GB-Int'
 ELSE a.strCountryCode
 END AS [strCountryCode]
 FROM Bocss2.dbo.tblBAccountParticipant AS ap
 INNER JOIN Bocss2.dbo.tblBAccountParticipantAddress AS apa ON ap.lngParticipantID = apa.lngParticipantID
 AND apa.sintAddressTypeID = 2
 INNER JOIN Bocss2.dbo.tblBAccountHolder AS ah ON ap.lngParticipantID = ah.lngParticipantID
 INNER JOIN Bocss2.dbo.tblBAddress AS a ON apa.lngAddressID = a.lngAddressID
 AND a.blnIsCurrent = 1
 INNER JOIN Bocss2.dbo.tblBOrder AS o ON ap.lngParticipantID = o.lngAccountParticipantID
 AND o.sdtmOrdCreated >= @FromDate
 AND o.sdtmOrdCreated < @ToDate

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