SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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);
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;
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

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
null
1
E
null

2
A
D
null
null
null
null

3
B
C
null
3
E
null




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
null
1
E
null

3
B
C
null
3
E
null

2
A
D
null
null
null
null




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
null
1
E
null

3
B
C
null
3
E
null




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>
pk	c1	c2	padding1	fk	c3	padding2
1	A	B	null	1	E	null
2	A	D	null	null	null	null
3	B	C	null	3	E	null
pk	c1	c2	padding1	fk	c3	padding2
1	A	B	null	1	E	null
3	B	C	null	3	E	null
2	A	D	null	null	null	null