clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601421 fiddles created (47999 in the last week).

CREATE TABLE dbo.T553 ( pk integer PRIMARY KEY CLUSTERED, c1 varchar(10) NULL, c2 varchar(10) NULL, padding1 ntext NULL ); CREATE TABLE dbo.T1011 ( fk integer PRIMARY KEY CLUSTERED FOREIGN KEY REFERENCES dbo.T553, c3 varchar(10) NULL, padding2 ntext NULL ); CREATE NONCLUSTERED INDEX ic1 ON dbo.T553 (c1); CREATE NONCLUSTERED INDEX ic2 ON dbo.T553 (c2); CREATE NONCLUSTERED INDEX ic3 ON dbo.T1011 (c3);
 hidden batch(es)


CREATE VIEW dbo.T1617 WITH SCHEMABINDING AS SELECT T1.pk, T1.c1, T1.c2, T1.padding1, T2.fk, T2.c3, T2.padding2 FROM dbo.T553 AS T1 LEFT JOIN dbo.T1011 AS T2 ON T2.fk = T1.pk;
 hidden batch(es)


INSERT dbo.T553 (pk, c1, c2) VALUES (1, 'A', 'B'), (2, 'A', 'D'), (3, 'B', 'C'), (4, 'B', 'C'); INSERT dbo.T1011 (fk, c3) VALUES (1, 'E'), (3, 'E'); --UPDATE STATISTICS dbo.T553 WITH ROWCOUNT = 1514640, PAGECOUNT = 151464; --UPDATE STATISTICS dbo.T1011 WITH ROWCOUNT = 1282750, PAGECOUNT = 128275;
6 rows affected
 hidden batch(es)


set statistics xml on; DECLARE @P0 varchar(10) = 'A', @P1 varchar(10) = 'D', @P2 varchar(10) = 'E'; -- Original SELECT T.* FROM dbo.T1617 AS T WHERE T.c1 LIKE @P0 OR T.c2 LIKE @P1 OR T.c3 LIKE @P2; -- After manual OR expansion SELECT T1617.* FROM dbo.T1617 AS T1617 WITH (FORCESEEK) WHERE T1617.c3 LIKE @P2 UNION ALL SELECT T1617.* FROM dbo.T1617 AS T1617 WITH (FORCESEEK) WHERE 0 = IIF(T1617.c3 LIKE @P2, 1, 0) AND ( T1617.c1 LIKE @P0 OR T1617.c2 LIKE @P1 ); -- Specific example happy to reject nulls resulting from the view outer join SELECT T1617.* FROM dbo.T1617 AS T1617 WITH (FORCESEEK) WHERE T1617.c3 LIKE @P2 UNION ALL SELECT T1617.* FROM dbo.T1617 AS T1617 WITH (FORCESEEK) WHERE ( NOT T1617.c3 LIKE @P2 ) AND ( T1617.c1 LIKE @P0 OR T1617.c2 LIKE @P1 );
pk c1 c2 padding1 fk c3 padding2
1 A B 1 E
2 A D
3 B C 3 E
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5698.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT&#xa; T.* &#xa;FROM dbo.T1617 AS T&#xa;WHERE &#xa; T.c1 LIKE @P0&#xa; OR T.c2 LIKE @P1&#xa; OR T.c3 LIKE @P2" StatementId="1" StatementCompId="3" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00685806" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xB2B62AC957941128" QueryPlanHash="0x670D38DA906605D7" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130"><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="40" CompileTime="12" CompileCPU="12" CompileMemory="352"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2536128"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2021-04-12T14:31:30.03" ModificationCount="0" SamplingPercent="100" Statistics="[PK__T553__321403CF4AD5B5BC]" Table="[T553]" Schema="[dbo]" Database="[fiddle_7553bbc070934301b4982ec55a904cad]"></StatisticsInfo><StatisticsInfo LastUpdate="2021-04-12T14:31:30.04" ModificationCount="0" SamplingPercent="100" Statistics="[PK__T1011__32139186A3965B6C]" Table="[T1011]" Schema="[dbo]" Database="[fiddle_7553bbc070934301b4982ec55a904cad]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="9.52e-006" AvgRowSize="178" EstimatedTotalSubtreeCost="0.00685806" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="4" EstimateIO="0" EstimateCPU="3.344e-005" AvgRowSize="178" EstimatedTotalSubtreeCost="0.00684854" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[fk] as [T2].[fk]=[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[pk] as [T1].[pk]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="2" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="97" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[PK__T553__321403CF4AD5B5BC]" Alias="[T1]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimatedRowsRead="2" EstimateIO="0.0032035" EstimateCPU="8.07e-005" AvgRowSize="90" EstimatedTotalSubtreeCost="0.0035263" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="9" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="8" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Index="[PK__T1011__32139186A3965B6C]" Alias="[T2]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[c1] as [T1].[c1] like [@P0] OR [fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[c2] as [T1].[c2] like [@P1] OR [fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[c3] as [T2].[c3] like [@P2]"><Logical Operation="OR"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><ParameterList><ColumnReference Column="@P2" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;E&apos;"></ColumnReference><ColumnReference Column="@P1" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;D&apos;"></ColumnReference><ColumnReference Column="@P0" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;A&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
pk c1 c2 padding1 fk c3 padding2
1 A B 1 E
3 B C 3 E
2 A D
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5698.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT &#xa; T1617.*&#xa;FROM dbo.T1617 AS T1617&#xa; WITH (FORCESEEK)&#xa;WHERE &#xa; T1617.c3 LIKE @P2&#xa;&#xa;UNION ALL&#xa;&#xa;SELECT&#xa; T1617.*&#xa;FROM dbo.T1617 AS T1617&#xa; WITH (FORCESEEK)&#xa;WHERE&#xa; 0 = IIF(T1617.c3 LIKE @P2, 1, 0)&#xa; AND&#xa; (&#xa; T1617.c1 LIKE @P0&#xa; OR T1617.c2 LIKE @P1&#xa; )" StatementId="2" StatementCompId="4" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0344591" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x64DC570039F76854" QueryPlanHash="0xEB5DE7CB224F452F" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130"><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="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="96" CompileTime="0" CompileCPU="0" CompileMemory="608"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="16" MaxQueryMemory="697096"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2536128"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2021-04-12T14:31:30.03" ModificationCount="0" SamplingPercent="100" Statistics="[PK__T553__321403CF4AD5B5BC]" Table="[T553]" Schema="[dbo]" Database="[fiddle_7553bbc070934301b4982ec55a904cad]"></StatisticsInfo><StatisticsInfo LastUpdate="2021-04-12T14:31:30.04" ModificationCount="0" SamplingPercent="100" Statistics="[PK__T1011__32139186A3965B6C]" Table="[T1011]" Schema="[dbo]" Database="[fiddle_7553bbc070934301b4982ec55a904cad]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-007" AvgRowSize="178" EstimatedTotalSubtreeCost="0.0344591" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Column="Union1007"></ColumnReference><ColumnReference Column="Union1008"></ColumnReference><ColumnReference Column="Union1009"></ColumnReference><ColumnReference Column="Union1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1007"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1008"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1009"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="178" EstimatedTotalSubtreeCost="0.00985854" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></OuterReferences><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="90" EstimatedTotalSubtreeCost="0.00657126" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference></OuterReferences><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="27" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="LikeRangeStart([@P2])"><Identifier><ColumnReference Column="ConstExpr1011"><ScalarOperator><Intrinsic FunctionName="LikeRangeStart"><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="LikeRangeEnd([@P2])"><Identifier><ColumnReference Column="ConstExpr1012"><ScalarOperator><Intrinsic FunctionName="LikeRangeEnd"><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="LikeRangeInfo([@P2])"><Identifier><ColumnReference Column="ConstExpr1013"><ScalarOperator><Intrinsic FunctionName="LikeRangeInfo"><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="6" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Index="[ic3]" Alias="[T2]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1020]"><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1021]"><Identifier><ColumnReference Column="Expr1021"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[c3] as [T2].[c3] like [@P2]"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="8" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="79" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Index="[PK__T1011__32139186A3965B6C]" Alias="[T2]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[fk] as [T2].[fk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="9" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="97" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[PK__T553__321403CF4AD5B5BC]" Alias="[T1]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[fk] as [T2].[fk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="10" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="1.98e-006" AvgRowSize="178" EstimatedTotalSubtreeCost="0.0246004" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="11" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="178" EstimatedTotalSubtreeCost="0.0245984" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OuterReferences><RelOp NodeId="12" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="6.53125e-006" AvgRowSize="97" EstimatedTotalSubtreeCost="0.0213111" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OuterReferences><RelOp NodeId="13" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1.5625" EstimateIO="0.0112613" EstimateCPU="0.000103131" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0179326" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="14" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00656816" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="15" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference></OuterReferences><RelOp NodeId="16" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="27" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="LikeRangeStart([@P0])"><Identifier><ColumnReference Column="ConstExpr1014"><ScalarOperator><Intrinsic FunctionName="LikeRangeStart"><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="LikeRangeEnd([@P0])"><Identifier><ColumnReference Column="ConstExpr1015"><ScalarOperator><Intrinsic FunctionName="LikeRangeEnd"><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1025"></ColumnReference><ScalarOperator ScalarString="LikeRangeInfo([@P0])"><Identifier><ColumnReference Column="ConstExpr1016"><ScalarOperator><Intrinsic FunctionName="LikeRangeInfo"><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="18" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[ic1]" Alias="[T1]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1023]"><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1024]"><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[c1] as [T1].[c1] like [@P0]"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="19" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OuterReferences><RelOp NodeId="20" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="27" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="LikeRangeStart([@P1])"><Identifier><ColumnReference Column="ConstExpr1017"><ScalarOperator><Intrinsic FunctionName="LikeRangeStart"><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="LikeRangeEnd([@P1])"><Identifier><ColumnReference Column="ConstExpr1018"><ScalarOperator><Intrinsic FunctionName="LikeRangeEnd"><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="LikeRangeInfo([@P1])"><Identifier><ColumnReference Column="ConstExpr1019"><ScalarOperator><Intrinsic FunctionName="LikeRangeInfo"><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="21" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="22" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[ic2]" Alias="[T1]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1026]"><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1027]"><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[c2] as [T1].[c2] like [@P1]"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp></Concat></RelOp></Sort></RelOp><RelOp NodeId="24" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="93" EstimatedTotalSubtreeCost="0.00337203" TableCardinality="4" Parallel="0" EstimateRebinds="0.5625" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[PK__T553__321403CF4AD5B5BC]" Alias="[T1]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[pk] as [T1].[pk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="25" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="90" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Index="[PK__T1011__32139186A3965B6C]" Alias="[T2]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[pk] as [T1].[pk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="(0)=CASE WHEN [fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[c3] as [T2].[c3] like [@P2] THEN (1) ELSE (0) END"><Compare CompareOp="EQ"><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Concat></RelOp><ParameterList><ColumnReference Column="@P1" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;D&apos;"></ColumnReference><ColumnReference Column="@P0" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;A&apos;"></ColumnReference><ColumnReference Column="@P2" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;E&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
pk c1 c2 padding1 fk c3 padding2
1 A B 1 E
3 B C 3 E
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.518" Build="13.0.5698.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT &#xa; T1617.*&#xa;FROM dbo.T1617 AS T1617&#xa; WITH (FORCESEEK)&#xa;WHERE &#xa; T1617.c3 LIKE @P2&#xa;&#xa;UNION ALL&#xa;&#xa;SELECT&#xa; T1617.*&#xa;FROM dbo.T1617 AS T1617&#xa; WITH (FORCESEEK)&#xa;WHERE&#xa; (&#xa; NOT T1617.c3 LIKE @P2&#xa; )&#xa; AND&#xa; (&#xa; T1617.c1 LIKE @P0&#xa; OR T1617.c2 LIKE @P1&#xa; )" StatementId="3" StatementCompId="5" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0344581" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x75FB6678297ED1AF" QueryPlanHash="0x12CA33AD7C1E9705" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130"><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="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="96" CompileTime="14" CompileCPU="14" CompileMemory="656"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="16" MaxQueryMemory="697096"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2536128"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2021-04-12T14:31:30.03" ModificationCount="0" SamplingPercent="100" Statistics="[PK__T553__321403CF4AD5B5BC]" Table="[T553]" Schema="[dbo]" Database="[fiddle_7553bbc070934301b4982ec55a904cad]"></StatisticsInfo><StatisticsInfo LastUpdate="2021-04-12T14:31:30.04" ModificationCount="0" SamplingPercent="100" Statistics="[PK__T1011__32139186A3965B6C]" Table="[T1011]" Schema="[dbo]" Database="[fiddle_7553bbc070934301b4982ec55a904cad]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-007" AvgRowSize="178" EstimatedTotalSubtreeCost="0.0344581" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Column="Union1007"></ColumnReference><ColumnReference Column="Union1008"></ColumnReference><ColumnReference Column="Union1009"></ColumnReference><ColumnReference Column="Union1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1004"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1005"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1006"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1007"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1008"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1009"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="178" EstimatedTotalSubtreeCost="0.00985854" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></OuterReferences><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="90" EstimatedTotalSubtreeCost="0.00657126" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference></OuterReferences><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="27" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1023"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1025"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="LikeRangeStart([@P2])"><Identifier><ColumnReference Column="ConstExpr1011"><ScalarOperator><Intrinsic FunctionName="LikeRangeStart"><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="LikeRangeEnd([@P2])"><Identifier><ColumnReference Column="ConstExpr1012"><ScalarOperator><Intrinsic FunctionName="LikeRangeEnd"><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1025"></ColumnReference><ScalarOperator ScalarString="LikeRangeInfo([@P2])"><Identifier><ColumnReference Column="ConstExpr1013"><ScalarOperator><Intrinsic FunctionName="LikeRangeInfo"><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="6" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Index="[ic3]" Alias="[T2]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1023]"><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1024]"><Identifier><ColumnReference Column="Expr1024"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[c3] as [T2].[c3] like [@P2]"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="8" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="79" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Index="[PK__T1011__32139186A3965B6C]" Alias="[T2]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[fk] as [T2].[fk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="9" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="97" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[PK__T553__321403CF4AD5B5BC]" Alias="[T1]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[fk] as [T2].[fk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="10" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="178" EstimatedTotalSubtreeCost="0.0245994" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OuterReferences><RelOp NodeId="11" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="6.53125e-006" AvgRowSize="97" EstimatedTotalSubtreeCost="0.0213111" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OuterReferences><RelOp NodeId="12" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1.5625" EstimateIO="0.0112613" EstimateCPU="0.000103131" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0179326" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="13" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-007" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00656816" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OuterReferences><RelOp NodeId="15" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="27" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="LikeRangeStart([@P0])"><Identifier><ColumnReference Column="ConstExpr1017"><ScalarOperator><Intrinsic FunctionName="LikeRangeStart"><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="LikeRangeEnd([@P0])"><Identifier><ColumnReference Column="ConstExpr1018"><ScalarOperator><Intrinsic FunctionName="LikeRangeEnd"><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="LikeRangeInfo([@P0])"><Identifier><ColumnReference Column="ConstExpr1019"><ScalarOperator><Intrinsic FunctionName="LikeRangeInfo"><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="17" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[ic1]" Alias="[T1]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1026]"><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1027]"><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[c1] as [T1].[c1] like [@P0]"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P0"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="18" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OuterReferences><RelOp NodeId="19" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="27" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="LikeRangeStart([@P1])"><Identifier><ColumnReference Column="ConstExpr1020"><ScalarOperator><Intrinsic FunctionName="LikeRangeStart"><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="LikeRangeEnd([@P1])"><Identifier><ColumnReference Column="ConstExpr1021"><ScalarOperator><Intrinsic FunctionName="LikeRangeEnd"><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="LikeRangeInfo([@P1])"><Identifier><ColumnReference Column="ConstExpr1022"><ScalarOperator><Intrinsic FunctionName="LikeRangeInfo"><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="20" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="21" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="4" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[ic2]" Alias="[T1]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1029]"><Identifier><ColumnReference Column="Expr1029"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1030]"><Identifier><ColumnReference Column="Expr1030"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[c2] as [T1].[c2] like [@P1]"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P1"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp></Concat></RelOp></Sort></RelOp><RelOp NodeId="23" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="93" EstimatedTotalSubtreeCost="0.00337203" TableCardinality="4" Parallel="0" EstimateRebinds="0.5625" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c1"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="c2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="padding1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Index="[PK__T553__321403CF4AD5B5BC]" Alias="[T1]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[pk] as [T1].[pk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="24" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="90" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="2" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="padding2"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Index="[PK__T1011__32139186A3965B6C]" Alias="[T2]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="fk"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T553].[pk] as [T1].[pk]"><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T553]" Alias="[T1]" Column="pk"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="NOT [fiddle_7553bbc070934301b4982ec55a904cad].[dbo].[T1011].[c3] as [T2].[c3] like [@P2]"><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_7553bbc070934301b4982ec55a904cad]" Schema="[dbo]" Table="[T1011]" Alias="[T2]" Column="c3"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@P2"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp></Concat></RelOp><ParameterList><ColumnReference Column="@P1" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;D&apos;"></ColumnReference><ColumnReference Column="@P0" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;A&apos;"></ColumnReference><ColumnReference Column="@P2" ParameterDataType="varchar(10)" ParameterRuntimeValue="&apos;E&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
 hidden batch(es)