SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.BigNumbers 
(
    col1 tinyint NOT NULL,
    col2 tinyint NOT NULL,
    col3 tinyint NOT NULL,

    CONSTRAINT CUQ_BigNumbers UNIQUE
        CLUSTERED (col1, col2, col3)
);
WITH Hundred AS
(
    SELECT n = CONVERT(tinyint, SV.number)
    FROM master.dbo.spt_values AS SV
    WHERE 
        SV.[type] = N'P'
        AND SV.number BETWEEN 0 AND 100
)
INSERT dbo.BigNumbers
    (col1, col2, col3)
SELECT H1.n, H2.n, H3.n
FROM Hundred AS H1
CROSS JOIN Hundred AS H2
CROSS JOIN Hundred AS H3;
1030301 rows affected

SET STATISTICS XML ON;

DECLARE 
    @x1 tinyint = 60,
    @x2 tinyint = 40,
    @x3 tinyint = 98;

SELECT TOP (5) 
    BN.col1, 
    BN.col2, 
    BN.col3 
FROM dbo.BigNumbers AS BN
WHERE 
    (BN.col1 = @x1 AND BN.col2 = @x2 AND BN.col3 >= @x3)
    OR (BN.col1 = @x1 AND BN.col2 > @x2)
    OR (BN.col1 > @x1)
ORDER BY 
    BN.col1, 
    BN.col2, 
    BN.col3;


col1
col2
col3


60
40
98

60
40
99

60
40
100

60
41
0

60
41
1




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4223.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT TOP (5) &#xd;&#xa;    BN.col1, &#xd;&#xa;    BN.col2, &#xd;&#xa;    BN.col3 &#xd;&#xa;FROM dbo.BigNumbers AS BN&#xd;&#xa;WHERE &#xd;&#xa;    (BN.col1 = @x1 AND BN.col2 = @x2 AND BN.col3 &gt;= @x3)&#xd;&#xa;    OR (BN.col1 = @x1 AND BN.col2 &gt; @x2)&#xd;&#xa;    OR (BN.col1 &gt; @x1)&#xd;&#xa;ORDER BY &#xd;&#xa;    BN.col1, &#xd;&#xa;    BN.col2, &#xd;&#xa;    BN.col3" StatementId="1" StatementCompId="3" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00329752" StatementEstRows="5" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x75DCBC75BD2A9D6E" QueryPlanHash="0x440927A5CC0FE22C" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="24" CompileTime="953" CompileCPU="953" CompileMemory="216"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1427304"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-08-31T11:08:20.26" ModificationCount="0" SamplingPercent="32.7209" Statistics="[CUQ_BigNumbers]" Table="[BigNumbers]" Schema="[dbo]" Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-08-31T11:08:20.68" ModificationCount="0" SamplingPercent="32.7209" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[BigNumbers]" Schema="[dbo]" Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Top" LogicalOp="Top" EstimateRows="5" EstimateIO="0" EstimateCPU="5e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="0.00329752" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(5)"><Const ConstValue="(5)"></Const></ScalarOperator></TopExpression><RelOp NodeId="1" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="5" EstimateRowsWithoutRowGoal="311180" EstimatedRowsRead="311180" EstimateIO="0.743866" EstimateCPU="0.342455" AvgRowSize="10" EstimatedTotalSubtreeCost="0.00329702" TableCardinality="1.0303e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="2" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="5" ActualEndOfScans="0" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Index="[CUQ_BigNumbers]" Alias="[BN]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x1]"><Identifier><ColumnReference Column="@x1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="[@x2]"><Identifier><ColumnReference Column="@x2"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x3]"><Identifier><ColumnReference Column="@x3"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x1]"><Identifier><ColumnReference Column="@x1"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x2]"><Identifier><ColumnReference Column="@x2"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x1]"><Identifier><ColumnReference Column="@x1"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Top></RelOp><ParameterList><ColumnReference Column="@x3" ParameterDataType="tinyint" ParameterRuntimeValue="(98)"></ColumnReference><ColumnReference Column="@x2" ParameterDataType="tinyint" ParameterRuntimeValue="(40)"></ColumnReference><ColumnReference Column="@x1" ParameterDataType="tinyint" ParameterRuntimeValue="(60)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


DECLARE 
    @x1 tinyint = 60,
    @x2 tinyint = 40,
    @x3 tinyint = 98;

SELECT BN.col1, BN.col2, BN.col3 
FROM dbo.BigNumbers AS BN 
WHERE BN.col1 = @x1 
AND BN.col2 = @x2 
AND BN.col3 >= @x3

UNION ALL 

SELECT BN.col1, BN.col2, BN.col3 
FROM dbo.BigNumbers AS BN 
WHERE BN.col1 = @x1 
AND BN.col2 > @x2

UNION ALL 

SELECT BN.col1, BN.col2, BN.col3 
FROM dbo.BigNumbers AS BN 
WHERE BN.col1 > @x1

ORDER BY BN.col1, BN.col2, BN.col3
OFFSET 0 ROWS 
FETCH FIRST 5 ROWS ONLY;


col1
col2
col3


60
40
98

60
40
99

60
40
100

60
41
0

60
41
1




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4223.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT BN.col1, BN.col2, BN.col3 &#xd;&#xa;FROM dbo.BigNumbers AS BN &#xd;&#xa;WHERE BN.col1 = @x1 &#xd;&#xa;AND BN.col2 = @x2 &#xd;&#xa;AND BN.col3 &gt;= @x3&#xd;&#xa;&#xd;&#xa;UNION ALL &#xd;&#xa;&#xd;&#xa;SELECT BN.col1, BN.col2, BN.col3 &#xd;&#xa;FROM dbo.BigNumbers AS BN &#xd;&#xa;WHERE BN.col1 = @x1 &#xd;&#xa;AND BN.col2 &gt; @x2&#xd;&#xa;&#xd;&#xa;UNION ALL &#xd;&#xa;&#xd;&#xa;SELECT BN.col1, BN.col2, BN.col3 &#xd;&#xa;FROM dbo.BigNumbers AS BN &#xd;&#xa;WHERE BN.col1 &gt; @x1&#xd;&#xa;&#xd;&#xa;ORDER BY BN.col1, BN.col2, BN.col3&#xd;&#xa;OFFSET 0 ROWS &#xd;&#xa;FETCH FIRST 5 ROWS ONLY" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0404509" StatementEstRows="5" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x381F800C34E88FD4" QueryPlanHash="0xA0DE3735524F9306" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="453" CompileCPU="453" CompileMemory="328"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1427304"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-08-31T11:08:20.26" ModificationCount="0" SamplingPercent="32.7209" Statistics="[CUQ_BigNumbers]" Table="[BigNumbers]" Schema="[dbo]" Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-08-31T11:08:20.68" ModificationCount="0" SamplingPercent="32.7209" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[BigNumbers]" Schema="[dbo]" Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-08-31T11:08:21.15" ModificationCount="0" SamplingPercent="32.7209" Statistics="[_WA_Sys_00000003_22AA2996]" Table="[BigNumbers]" Schema="[dbo]" Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Top" LogicalOp="Top" EstimateRows="5" EstimateIO="0" EstimateCPU="5e-07" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0404509" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1003"></ColumnReference><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(5)"><Const ConstValue="(5)"></Const></ScalarOperator></TopExpression><RelOp NodeId="1" PhysicalOp="Merge Join" LogicalOp="Concatenation" EstimateRows="5" EstimateRowsWithoutRowGoal="315429" EstimateIO="0" EstimateCPU="0.349772" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0404504" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1003"></ColumnReference><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1003"></ColumnReference><ColumnReference Column="Union1003"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Merge Join" LogicalOp="Concatenation" EstimateRows="5" EstimateRowsWithoutRowGoal="315429" EstimateIO="0" EstimateCPU="0.349772" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0218717" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1003"></ColumnReference><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1003"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="5" EstimateRowsWithoutRowGoal="751.212" EstimatedRowsRead="751.212" EstimateIO="0.00417357" EstimateCPU="0.000983333" AvgRowSize="10" EstimatedTotalSubtreeCost="0.00329309" TableCardinality="1.0303e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Index="[CUQ_BigNumbers]" Alias="[BN]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x1]"><Identifier><ColumnReference Column="@x1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="[@x2]"><Identifier><ColumnReference Column="@x2"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x3]"><Identifier><ColumnReference Column="@x3"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="4" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateRowsWithoutRowGoal="5587.32" EstimatedRowsRead="5587.32" EstimateIO="0.0157176" EstimateCPU="0.00630305" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1.0303e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Index="[CUQ_BigNumbers]" Alias="[BN]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x1]"><Identifier><ColumnReference Column="@x1"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x2]"><Identifier><ColumnReference Column="@x2"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Merge></RelOp><RelOp NodeId="5" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateRowsWithoutRowGoal="309090" EstimatedRowsRead="309090" EstimateIO="0.738681" EstimateCPU="0.340156" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1.0303e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="0" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Index="[CUQ_BigNumbers]" Alias="[BN]" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_2efb1ca0d17343839d61f054e4d1edb2]" Schema="[dbo]" Table="[BigNumbers]" Alias="[BN]" Column="col1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@x1]"><Identifier><ColumnReference Column="@x1"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Merge></RelOp></Top></RelOp><ParameterList><ColumnReference Column="@x3" ParameterDataType="tinyint" ParameterRuntimeValue="(98)"></ColumnReference><ColumnReference Column="@x2" ParameterDataType="tinyint" ParameterRuntimeValue="(40)"></ColumnReference><ColumnReference Column="@x1" ParameterDataType="tinyint" ParameterRuntimeValue="(60)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>