SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE PARTITION FUNCTION pf_test(int) AS RANGE RIGHT FOR VALUES(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
CREATE PARTITION SCHEME ps_test AS PARTITION pf_test ALL TO([PRIMARY])
Partition scheme 'ps_test' has been created successfully. 'PRIMARY' is marked as the next used filegroup in partition scheme 'ps_test'.


CREATE TABLE test_not_computed(
ID BIGINT NOT NULL, 
ID_C INT NOT NULL, 
PRIMARY KEY CLUSTERED(ID, ID_C) ON ps_test(ID_C)
) ON ps_test(ID_C)
INSERT INTO test_not_computed(ID, ID_C)
SELECT TOP 10000 
  ROW_NUMBER() OVER(ORDER BY GETDATE()),
  ROW_NUMBER() OVER(ORDER BY GETDATE()) / 1000
FROM sys.all_columns a
CROSS JOIN sys.all_columns b
10000 rows affected

update statistics test_not_computed with fullscan;
set statistics xml on;
SELECT ID, ID_C
FROM (
  SELECT *, ROW_NUMBER() OVER (PARTITION BY $partition.pf_test(ID_C) ORDER BY ID) AS rn
  FROM test_not_computed
) t
WHERE rn = 1;


ID
ID_C


1
0

1000
1

2000
2

3000
3

4000
4

5000
5

6000
6

7000
7

8000
8

9000
9

10000
10




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT ID, ID_C&#xa;FROM (&#xa;  SELECT *, ROW_NUMBER() OVER (PARTITION BY $partition.pf_test(ID_C) ORDER BY ID) AS rn&#xa;  FROM test_not_computed&#xa;) t&#xa;WHERE rn = 1" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x0900BDA70FEE641B554ED8E005967D6500CF0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0860729" StatementEstRows="10000" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xAFFC85507B23C52F" QueryPlanHash="0xD8FD45EBF0D9B5C4" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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="0" CompileCPU="0" CompileMemory="232"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2107856"></OptimizerHardwareDependentProperties><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="16" CpuTime="16"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="10000" EstimateIO="0" EstimateCPU="0.0048" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0860729" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="16" ActualCPUms="16" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="10000" EstimateIO="0" EstimateCPU="0.0008" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0812729" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10000" Batches="0" ActualElapsedms="16" ActualCPUms="16" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="10000" EstimateIO="0" EstimateCPU="0.0002" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0804729" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="PtnId1000" ComputedColumn="1"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Segment1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10000" Batches="0" ActualElapsedms="16" ActualCPUms="16" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Column="Expr1003"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1005"></ColumnReference></SegmentColumn><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="10000" EstimateIO="0" EstimateCPU="0.001" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0802729" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="PtnId1000" ComputedColumn="1"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="[PtnId1000]"><Identifier><ColumnReference Column="PtnId1000" ComputedColumn="1"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="10000" EstimatedRowsRead="10000" EstimateIO="0.0663889" EstimateCPU="0.012884" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0792729" TableCardinality="10000" Parallel="0" Partitioned="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="PtnId1000" ComputedColumn="1"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10000" Batches="0" ActualElapsedms="16" ActualCPUms="16" ActualScans="12" ActualLogicalReads="73" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="10000" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><RunTimePartitionSummary><PartitionsAccessed PartitionCount="12"><PartitionRange Start="1" End="12"></PartitionRange></PartitionsAccessed></RunTimePartitionSummary><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Column="PtnId1000" ComputedColumn="1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Index="[PK__test_not__B993067777993728]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Segment></RelOp></SequenceProject></RelOp><Predicate><ScalarOperator ScalarString="[Expr1004]=(1)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


SELECT t.*
FROM (
    SELECT 1
    UNION ALL
    SELECT LEAD(rv.boundary_id, 1, rv.boundary_id + 1) OVER (ORDER BY rv.boundary_id)
    FROM sys.partition_functions pf
    JOIN sys.partition_range_values rv ON rv.function_id = pf.function_id AND pf.name = 'pf_test'
) rv(boundary_id)
CROSS APPLY (
  SELECT TOP (1) *
  FROM test_not_computed
  WHERE $partition.pf_test(ID_C) = rv.boundary_id
  ORDER BY ID
) t;


ID
ID_C


1
0

1000
1

2000
2

3000
3

4000
4

5000
5

6000
6

7000
7

8000
8

9000
9

10000
10




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT t.*&#xa;FROM (&#xa;    SELECT 1&#xa;    UNION ALL&#xa;    SELECT LEAD(rv.boundary_id, 1, rv.boundary_id + 1) OVER (ORDER BY rv.boundary_id)&#xa;    FROM sys.partition_functions pf&#xa;    JOIN sys.partition_range_values rv ON rv.function_id = pf.function_id AND pf.name = &apos;pf_test&apos;&#xa;) rv(boundary_id)&#xa;CROSS APPLY (&#xa;  SELECT TOP (1) *&#xa;  FROM test_not_computed&#xa;  WHERE $partition.pf_test(ID_C) = rv.boundary_id&#xa;  ORDER BY ID&#xa;) t" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x0900FC618124AE86AB2F1C2D596496BB692C0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0100252" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x86AFDEF02E7365B8" QueryPlanHash="0xA2723769ECCD77B5" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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="64" CompileTime="15" CompileCPU="15" CompileMemory="792"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2107856"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-06-07T13:39:24.47" ModificationCount="1" SamplingPercent="100" Statistics="[_WA_Sys_00000002_0000003C]" Table="[sysobjvalues]" Schema="[sys]" Database="[fiddle_9e87adb1fcec48049b78beed1650184c]"></StatisticsInfo><StatisticsInfo LastUpdate="2009-04-13T12:59:17.34" ModificationCount="308" SamplingPercent="100" Statistics="[clst]" Table="[sysobjvalues]" Schema="[sys]" Database="[fiddle_9e87adb1fcec48049b78beed1650184c]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-12-31T12:18:32.38" ModificationCount="5" SamplingPercent="100" Statistics="[_WA_Sys_00000002_00000040]" Table="[sysclsobjs]" Schema="[sys]" Database="[fiddle_9e87adb1fcec48049b78beed1650184c]"></StatisticsInfo><StatisticsInfo LastUpdate="2009-04-13T12:59:17.32" ModificationCount="17" SamplingPercent="100" Statistics="[clst]" Table="[sysclsobjs]" Schema="[sys]" Database="[fiddle_9e87adb1fcec48049b78beed1650184c]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-06-07T13:39:25.07" ModificationCount="0" SamplingPercent="100" Statistics="[PK__test_not__B993067777993728]" Table="[test_not_computed]" Schema="[dbo]" Database="[fiddle_9e87adb1fcec48049b78beed1650184c]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-06-07T13:39:25.10" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_35BCFE0A]" Table="[test_not_computed]" Schema="[dbo]" Database="[fiddle_9e87adb1fcec48049b78beed1650184c]"></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="Nested Loops" LogicalOp="Inner Join" EstimateRows="2" EstimateIO="0" EstimateCPU="8.36e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0100252" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Union1009"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-07" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00657528" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1009"></ColumnReference><ColumnReference Column="Expr1000"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1000"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00657392" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Count1016]=(0) THEN [Expr1013] ELSE [LastValue1015] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Count1016"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="LastValue1015"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="6.28e-07" AvgRowSize="47" EstimatedTotalSubtreeCost="0.00657382" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="LastValue1015"></ColumnReference><ColumnReference Column="Count1016"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Count1016"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="LastValue1015"></ColumnReference><ScalarOperator ScalarString="LAST_VALUE([fiddle_9e87adb1fcec48049b78beed1650184c].[sys].[sysobjvalues].[subobjid])"><Aggregate Distinct="0" AggType="LAST_VALUE"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1013])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1022"></ColumnReference></GroupBy><RelOp NodeId="5" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="2" EstimateIO="0" EstimateCPU="2.198e-06" AvgRowSize="47" EstimatedTotalSubtreeCost="0.00657319" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference><ColumnReference Column="WindowCount1022"></ColumnReference><ColumnReference Column="Segment1021"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="21" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1" EstimateIO="0" EstimateCPU="6.28e-08" AvgRowSize="47" EstimatedTotalSubtreeCost="0.00657074" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference><ColumnReference Column="TopRowNumber1018"></ColumnReference><ColumnReference Column="BottomRowNumber1019"></ColumnReference><ColumnReference Column="Segment1021"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1021"></ColumnReference></SegmentColumn><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="39" EstimatedTotalSubtreeCost="0.00657068" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference><ColumnReference Column="TopRowNumber1018"></ColumnReference><ColumnReference Column="BottomRowNumber1019"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="TopRowNumber1018"></ColumnReference><ScalarOperator ScalarString="[RowNumber1017]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="BottomRowNumber1019"></ColumnReference><ScalarOperator ScalarString="[RowNumber1017]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="8e-08" AvgRowSize="23" EstimatedTotalSubtreeCost="0.00657058" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1017"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-08" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0065705" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Segment1020"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1020"></ColumnReference></SegmentColumn><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00657048" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="[fiddle_9e87adb1fcec48049b78beed1650184c].[sys].[sysobjvalues].[subobjid]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00657038" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysclsobjs]" Alias="[f]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="12" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="29" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysclsobjs]" Alias="[f]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysclsobjs]" Alias="[f]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysclsobjs]" Index="[nc]" Alias="[f]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysclsobjs]" Alias="[f]" Column="name"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysclsobjs]" Alias="[f]" Column="class"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="N&apos;pf_test&apos;"><Const ConstValue="N&apos;pf_test&apos;"></Const></ScalarOperator><ScalarOperator ScalarString="(30)"><Const ConstValue="(30)"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="13" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="251" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="11" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="subobjid"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Index="[clst]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="valclass"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysobjvalues]" Column="objid"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(30)"><Const ConstValue="(30)"></Const></ScalarOperator><ScalarOperator ScalarString="[fiddle_9e87adb1fcec48049b78beed1650184c].[sys].[sysclsobjs].[id] as [f].[id]"><Identifier><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[sys]" Table="[sysclsobjs]" Alias="[f]" Column="id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Concat></RelOp><RelOp NodeId="14" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0034416" Parallel="0" EstimateRebinds="0" EstimateRewinds="1" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="12" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="16" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimateRowsWithoutRowGoal="909.091" EstimatedRowsRead="909.091" EstimateIO="0.00608796" EstimateCPU="0.001157" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0034412" TableCardinality="10000" Parallel="0" Partitioned="1" EstimateRebinds="0" EstimateRewinds="1" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="12" ActualLogicalReads="22" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="11" ActualEndOfScans="1" ActualExecutions="12" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><RunTimePartitionSummary><PartitionsAccessed PartitionCount="12"><PartitionRange Start="1" End="12"></PartitionRange></PartitionsAccessed></RunTimePartitionSummary><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Column="ID_C"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_9e87adb1fcec48049b78beed1650184c]" Schema="[dbo]" Table="[test_not_computed]" Index="[PK__test_not__B993067777993728]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Column="PtnId1010"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Union1009]"><Identifier><ColumnReference Column="Union1009"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Top></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>