SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE stackoverflow
(
  foo varchar(50),
  bar int
);
insert into stackoverflow values ('one', 1), ('two', 2), ('three', 3), ('four', 4);
4 rows affected

set statistics xml on
select so.*
  from stackoverflow so
 inner
  join (values (1), (2), (3)) copies(no)
    on copies.no = 1 -- first copy always
    or (copies.no = 2 and so.bar % 2 = 0) -- a copy for even bar records
    or (copies.no = 3 and so.foo like 't%') -- a copy for foo starting with 't'


foo
bar


one
1

two
2

two
2

two
2

three
3

three
3

four
4

four
4




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 so.*&#xa;  from stackoverflow so&#xa; inner&#xa;  join (values (1), (2), (3)) copies(no)&#xa;    on copies.no = 1 -- first copy always&#xa;    or (copies.no = 2 and so.bar % 2 = 0) -- a copy for even bar records&#xa;    or (copies.no = 3 and so.foo like &apos;t%&apos;)" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x09008BE83ADEEBFE562618462300DA842E9F0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.00337552" StatementEstRows="4" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x6C0C4255A3BB4224" QueryPlanHash="0x0358A26D03F73892" 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="264"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1463176"></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="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="4" EstimateIO="0" EstimateCPU="5.016e-05" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00337552" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[Union1005]=(1) OR [Expr1006]=(0) AND [Union1005]=(2) OR [Union1005]=(3) AND [fiddle_50b9ff2ea75f4ae9b3f4fee473952d19].[dbo].[stackoverflow].[foo] as [so].[foo] like &apos;t%&apos;"><Logical Operation="OR"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Union1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;t%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4" EstimateIO="0" EstimateCPU="4e-07" AvgRowSize="44" EstimatedTotalSubtreeCost="0.0032868" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19].[dbo].[stackoverflow].[bar] as [so].[bar]%(2)"><Arithmetic Operation="MOD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="3" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="3" EstimateIO="0" EstimateCPU="3.157e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="1.2157e-05" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


select so.*
  from stackoverflow so
 
  union all 
  
select so.*
  from stackoverflow so
where bar %2 = 0

  union all

select so.*
  from stackoverflow so
where foo like 't%'


foo
bar


one
1

two
2

three
3

four
4

two
2

four
4

two
2

three
3




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 so.*&#xa;  from stackoverflow so&#xa; &#xa;  union all &#xa;  &#xa;select so.*&#xa;  from stackoverflow so&#xa;where bar %2 = 0&#xa;&#xa;  union all&#xa;&#xa;select so.*&#xa;  from stackoverflow so&#xa;where foo like &apos;t%&apos;" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x0900EC7714900DC592E24B22017914F87A130000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.00986584" StatementEstRows="8" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4837364D44E9B1D5" QueryPlanHash="0x78AF8B57D2355EBE" 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="32" CompileTime="15" CompileCPU="15" CompileMemory="256"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1463176"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-02-27T19:06:30.26" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_35BCFE0A]" Table="[stackoverflow]" Schema="[dbo]" Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]"></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="Concatenation" LogicalOp="Concatenation" EstimateRows="8" EstimateIO="0" EstimateCPU="8e-07" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00986584" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Column="Union1007"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1007"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" TableReferenceId="1" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="3" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="2" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" TableReferenceId="2" IndexKind="Heap" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19].[dbo].[stackoverflow].[bar] as [so].[bar]%(2)=(0)"><Compare CompareOp="EQ"><ScalarOperator><Arithmetic Operation="MOD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></TableScan></RelOp><RelOp NodeId="4" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="2" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="bar"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" TableReferenceId="3" IndexKind="Heap" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19].[dbo].[stackoverflow].[foo] as [so].[foo] like &apos;t%&apos;"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_50b9ff2ea75f4ae9b3f4fee473952d19]" Schema="[dbo]" Table="[stackoverflow]" Alias="[so]" Column="foo"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;t%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Predicate></TableScan></RelOp></Concat></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>