SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (id INT, 
                   field_1 INT, 
                   field_2 INT, 
                   field_3 INT,
                   PRIMARY KEY (id));
CREATE INDEX idx ON test (field_1);
WITH 
cte AS (
    SELECT 1 id
    UNION ALL
    SELECT id + 1 FROM cte WHERE id < 1000
)
INSERT INTO test
SELECT id, RAND() * 100, RAND() * 50, RAND() * 40
FROM cte
OPTION (MAXRECURSION 1000);
1000 rows affected

set statistics xml on;
SELECT COUNT(*)
FROM test t1
JOIN test t2 ON t1.field_1 = t2.field_2 + t2.field_3 + 10;

(No column name)

0

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3335.7"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(*)&#xa;FROM test t1&#xa;JOIN test t2 ON t1.field_1 = t2.field_2 + t2.field_3 + 10" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0406526" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4E47BD22B1F36FD5" QueryPlanHash="0x8A49CCEAF28FCE15" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><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" MemoryGrant="1072" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="48" CompileTime="0" CompileCPU="0" CompileMemory="296"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1072" RequiredMemory="1024" DesiredMemory="1072" RequestedMemory="1072" GrantWaitTime="0" GrantedMemory="1072" MaxUsedMemory="104" MaxQueryMemory="496872"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="895024"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-02-24T15:23:48.93" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000004_34C8D9D1]" Table="[test]" Schema="[dbo]" Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T15:23:48.93" ModificationCount="0" SamplingPercent="100" Statistics="[idx]" Table="[test]" Schema="[dbo]" Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T15:23:48.93" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_34C8D9D1]" Table="[test]" Schema="[dbo]" Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]"></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="15" CpuTime="15"></QueryTimeStats><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0406526" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1005],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1005"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0006005" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0406525" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="globalagg1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="globalagg1005"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1004])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1004"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1000" EstimateIO="0" EstimateCPU="0.0253993" AvgRowSize="15" EstimatedTotalSubtreeCost="0.040052" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1004"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1072" OutputMemoryGrant="1072" UsedMemoryGrant="104"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1003"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_eacf6afc4d604396ac7da53db1064e0c].[dbo].[test].[field_1] as [t1].[field_1]=[Expr1003]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0006005" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00720472" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference><ColumnReference Column="partialagg1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="partialagg1004"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></GroupBy><RelOp NodeId="5" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1000" EstimatedRowsRead="1000" EstimateIO="0.00534722" EstimateCPU="0.001257" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00660422" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualScans="1" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1000" 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_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Index="[idx]" Alias="[t1]" IndexKind="NonClustered" Storage="RowStore"></Object></IndexScan></RelOp></StreamAggregate></RelOp><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1000" EstimateIO="0" EstimateCPU="0.0001" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00744496" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="[fiddle_eacf6afc4d604396ac7da53db1064e0c].[dbo].[test].[field_2] as [t2].[field_2]+[fiddle_eacf6afc4d604396ac7da53db1064e0c].[dbo].[test].[field_3] as [t2].[field_3]+(10)"><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_3"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1000" EstimatedRowsRead="1000" EstimateIO="0.00608796" EstimateCPU="0.001257" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00734496" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_2"></ColumnReference><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1000" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Index="[PK__test__3213E83FCD42C1A0]" Alias="[t2]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

set statistics xml on;
SELECT COUNT(*)
FROM test t1
JOIN test t2 ON t2.field_2 + t2.field_3 + 10 = t1.field_1;

(No column name)

0

Microsoft SQL Server 2005 XML Showplan

<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3335.7"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(*)&#xa;FROM test t1&#xa;JOIN test t2 ON t2.field_2 + t2.field_3 + 10 = t1.field_1" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0406526" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x5CB122714D97EF40" QueryPlanHash="0x8A49CCEAF28FCE15" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><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" MemoryGrant="1072" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="48" CompileTime="0" CompileCPU="0" CompileMemory="288"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1072" RequiredMemory="1024" DesiredMemory="1072" RequestedMemory="1072" GrantWaitTime="0" GrantedMemory="1072" MaxUsedMemory="104" MaxQueryMemory="496872"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="895024"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-02-24T15:23:48.93" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000004_34C8D9D1]" Table="[test]" Schema="[dbo]" Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T15:23:48.93" ModificationCount="0" SamplingPercent="100" Statistics="[idx]" Table="[test]" Schema="[dbo]" Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]"></StatisticsInfo><StatisticsInfo LastUpdate="2022-02-24T15:23:48.93" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_34C8D9D1]" Table="[test]" Schema="[dbo]" Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]"></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="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0406526" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[globalagg1005],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="globalagg1005"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0006005" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0406525" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="globalagg1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="globalagg1005"></ColumnReference><ScalarOperator ScalarString="SUM([partialagg1004])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Column="partialagg1004"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="1000" EstimateIO="0" EstimateCPU="0.0253993" AvgRowSize="15" EstimatedTotalSubtreeCost="0.040052" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="partialagg1004"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1072" OutputMemoryGrant="1072" UsedMemoryGrant="104"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Column="Expr1003"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[Expr1003]=[fiddle_eacf6afc4d604396ac7da53db1064e0c].[dbo].[test].[field_1] as [t1].[field_1]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0006005" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00720472" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference><ColumnReference Column="partialagg1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="partialagg1004"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></GroupBy><RelOp NodeId="5" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1000" EstimatedRowsRead="1000" EstimateIO="0.00534722" EstimateCPU="0.001257" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00660422" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1000" 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_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t1]" Column="field_1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Index="[idx]" Alias="[t1]" IndexKind="NonClustered" Storage="RowStore"></Object></IndexScan></RelOp></StreamAggregate></RelOp><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1000" EstimateIO="0" EstimateCPU="0.0001" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00744496" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="[fiddle_eacf6afc4d604396ac7da53db1064e0c].[dbo].[test].[field_2] as [t2].[field_2]+[fiddle_eacf6afc4d604396ac7da53db1064e0c].[dbo].[test].[field_3] as [t2].[field_3]+(10)"><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_3"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1000" EstimatedRowsRead="1000" EstimateIO="0.00608796" EstimateCPU="0.001257" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00734496" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_2"></ColumnReference><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1000" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Alias="[t2]" Column="field_3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_eacf6afc4d604396ac7da53db1064e0c]" Schema="[dbo]" Table="[test]" Index="[PK__test__3213E83FCD42C1A0]" Alias="[t2]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Hash></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>