SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- The test table
CREATE TABLE dbo.Example 
(
    id integer IDENTITY NOT NULL,
    string varchar(20) NOT NULL,
 
    CONSTRAINT [PK dbo.Example (id)]
        PRIMARY KEY CLUSTERED (id)
);

CREATE TABLE dbo.Numbers (n int PRIMARY KEY);
INSERT dbo.Numbers (n)
SELECT TOP (18) ROW_number() OVER (ORDER BY (SELECT NULL))
FROM master..spt_values;
18 rows affected

INSERT dbo.Example WITH (TABLOCKX)
    (string)
SELECT TOP (100000)
    -- 10 numeric characters
    REPLACE(STR(RAND(CHECKSUM(NEWID())) * 1e10, 10), SPACE(1), '0') +
    -- plus 10 mixed numeric + [A-F] characters
    RIGHT(NEWID(), 10)
FROM master.dbo.spt_values AS SV1
CROSS JOIN master.dbo.spt_values AS SV2
OPTION (MAXDOP 1);
100000 rows affected

CREATE VIEW ExampleTrigrams
WITH SCHEMABINDING
AS
SELECT
  trigram = CAST(SUBSTRING(e.string, n.n, 3) AS char(3)),
  e.id,
  count = COUNT_BIG(*)
FROM dbo.Example e
JOIN dbo.Numbers n ON n.n <= LEN(e.string)
WHERE
  -- Binary collation comparison so ranges work as expected
  SUBSTRING(e.string, n.n, 3) COLLATE Latin1_General_BIN2 NOT LIKE '%[^A-Z0-9a-z]%'
GROUP BY
  CAST(SUBSTRING(e.string, n.n, 3) AS char(3)),
  e.id;
CREATE UNIQUE CLUSTERED INDEX IX ON ExampleTrigrams (trigram, id) WITH (DATA_COMPRESSION = ROW)
CREATE VIEW TrigramCount
WITH SCHEMABINDING
AS
SELECT
  trigram = CAST(SUBSTRING(e.string, n.n, 3) AS char(3)),
  count = COUNT_BIG(*)
FROM dbo.Example e
JOIN dbo.Numbers n ON n.n <= LEN(e.string) - 2
WHERE
  -- Binary collation comparison so ranges work as expected
  SUBSTRING(e.string, n.n, 3) COLLATE Latin1_General_BIN2 NOT LIKE '%[^A-Z0-9a-z]%'
GROUP BY
  CAST(SUBSTRING(e.string, n.n, 3) AS char(3));
CREATE UNIQUE CLUSTERED INDEX IX ON TrigramCount (trigram) WITH (DATA_COMPRESSION = ROW)
CREATE FUNCTION dbo.Example_GetBestTrigrams (@string varchar(255))
RETURNS table
WITH SCHEMABINDING AS
RETURN
    SELECT
        -- Pivot
        trigram1 = MAX(CASE WHEN BT.rn = 1 THEN BT.trigram END),
        trigram2 = MAX(CASE WHEN BT.rn = 2 THEN BT.trigram END),
        trigram3 = MAX(CASE WHEN BT.rn = 3 THEN BT.trigram END)
FROM
(
    SELECT
        BT.trigram,
        rn = ROW_NUMBER() OVER (ORDER BY BT.count ASC)
    FROM 
    (
        -- Generate trigrams for the search string
        -- and choose the most selective three
        SELECT TOP (3)
            GT.trigram,
            ETC.count
        FROM
        (
           SELECT DISTINCT
              trigram = SUBSTRING(@string, n.n, 3)
           FROM dbo.Numbers n
           WHERE n.n <= LEN(@string) - 2
             AND
               -- Binary collation comparison so ranges work as expected
               SUBSTRING(@string, n.n, 3) COLLATE Latin1_General_BIN2 NOT LIKE '%[^A-Z0-9a-z]%'
        ) AS GT
        JOIN dbo.TrigramCount AS ETC
            WITH (NOEXPAND)
            ON ETC.trigram = GT.trigram
        ORDER BY
            ETC.count ASC
    ) AS BT
) AS BT;
CREATE FUNCTION dbo.Example_GetTrigramMatchIDs
(
    @Trigram1 char(3),
    @Trigram2 char(3),
    @Trigram3 char(3)
)
RETURNS TABLE
WITH SCHEMABINDING
AS RETURN
SELECT ET.id
FROM (
    SELECT ET1.id
    FROM dbo.ExampleTrigrams AS ET1 WITH (NOEXPAND)
    WHERE ET1.trigram = @Trigram1

    UNION ALL
    
    SELECT ET2.id
    FROM dbo.ExampleTrigrams AS ET2 WITH (NOEXPAND)
    WHERE ET2.trigram = @Trigram2

    UNION ALL
  
    SELECT ET3.id
    FROM dbo.ExampleTrigrams AS ET3 WITH (NOEXPAND)
    WHERE ET3.trigram = @Trigram3
) ET
GROUP BY
  ET.id
HAVING COUNT_BIG(*) = 1 + IIF(@Trigram2 IS NULL, 0, 1) + IIF(@Trigram3 IS NULL, 0, 1);
CREATE FUNCTION dbo.Example_TrigramSearch
(
    @Search varchar(255)
)
RETURNS table
WITH SCHEMABINDING
AS
RETURN
    SELECT
        E.string
    FROM dbo.Example_GetBestTrigrams(@Search) AS GBT
    CROSS APPLY dbo.Example_GetTrigramMatchIDs
            (GBT.trigram1, GBT.trigram2, GBT.trigram3) AS MID
    JOIN dbo.Example AS E
        ON E.id = MID.id
    WHERE
        -- At least one trigram found 
        GBT.trigram1 IS NOT NULL
        AND E.string LIKE @Search;
SET STATISTICS TIME, IO, XML ON
DECLARE @S datetime2;

SET @S = SYSUTCDATETIME();
 
SELECT F2.string
FROM dbo.Example AS F2
WHERE
    F2.string LIKE '%BEEF%'
OPTION (MAXDOP 1);
 
SELECT ElapsedMS = DATEDIFF(MILLISECOND, @S, SYSUTCDATETIME());

SET @S = SYSUTCDATETIME();
 
SELECT ETS.string
FROM dbo.Example_TrigramSearch('%BEEF%') AS ETS;
 
SELECT ElapsedMS = DATEDIFF(MILLISECOND, @S, SYSUTCDATETIME());


string


310361953507491BEEF3

638681101340E9FBEEF1

25669037926BEEF71332

65235213062EC4BEEF64

1444728162BEEF54DB8A

893000997303FBEEF6A6

876275424588BEEFD608

8187586856BEEFF39CE0


SQL Server parse and compile time: 
   CPU time = 1294 ms, elapsed time = 1294 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT F2.string&#xa;FROM dbo.Example AS F2&#xa;WHERE&#xa;    F2.string LIKE &apos;%BEEF%&apos;&#xa;OPTION (MAXDOP 1)" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x0900AC59AD63727BA340FC97CABB10E80EB60000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="2" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.58143" StatementEstRows="2.07555" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0xE9E4AB9DA94202D8" QueryPlanHash="0x12CCA55467D098AF" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="MaxDOPSetToOne" CachedPlanSize="16" CompileTime="15" CompileCPU="15" CompileMemory="360"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1011704"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-03-09T02:41:01.79" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_35BCFE0A]" Table="[Example]" Schema="[dbo]" Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="46" CpuTime="46"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2.07555" EstimatedRowsRead="100000" EstimateIO="0.471273" EstimateCPU="0.110157" AvgRowSize="21" EstimatedTotalSubtreeCost="0.58143" TableCardinality="100000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[F2]" Column="string"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualElapsedms="46" ActualCPUms="46" ActualScans="1" ActualLogicalReads="637" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="100000" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[F2]" Column="string"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Index="[PK dbo.Example (id)]" Alias="[F2]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_d2dd5e62994e42d4a2d26257f974a379].[dbo].[Example].[string] as [F2].[string] like &apos;%BEEF%&apos;"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[F2]" Column="string"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%BEEF%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


Table 'Example'. Scan count 1, logical reads 637, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.




ElapsedMS


47



 SQL Server Execution Times:
   CPU time = 46 ms,  elapsed time = 46 ms.




string


310361953507491BEEF3

638681101340E9FBEEF1

25669037926BEEF71332

65235213062EC4BEEF64

1444728162BEEF54DB8A

893000997303FBEEF6A6

876275424588BEEFD608

8187586856BEEFF39CE0



 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.
Warning: Null value is eliminated by an aggregate or other SET operation.




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT ETS.string&#xa;FROM dbo.Example_TrigramSearch(&apos;%BEEF%&apos;) AS ETS" StatementId="2" StatementCompId="5" StatementType="SELECT" StatementSqlHandle="0x09006087D845BC1B0677AA4241D184FCDCEA0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="2" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.522014" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x8A75855BD8D54D4F" QueryPlanHash="0x455F83A02AE3A1B4" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="88" CompileTime="1278" CompileCPU="1278" CompileMemory="1168"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="552" RequiredMemory="512" DesiredMemory="552" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="677096" GrantedMemory="1024" MaxUsedMemory="24"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1011960"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-03-09T02:41:21.43" ModificationCount="0" SamplingPercent="39.0645" Statistics="[_WA_Sys_00000002_398D8EEE]" Table="[ExampleTrigrams]" Schema="[dbo]" Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-03-09T02:41:21.48" ModificationCount="0" SamplingPercent="100" Statistics="[PK dbo.Example (id)]" Table="[Example]" Schema="[dbo]" Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-03-09T02:41:13.07" ModificationCount="0" SamplingPercent="100" Statistics="[IX]" Table="[ExampleTrigrams]" Schema="[dbo]" Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-03-09T02:41:01.79" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_35BCFE0A]" Table="[Example]" Schema="[dbo]" Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-03-09T02:41:20.21" ModificationCount="0" SamplingPercent="100" Statistics="[PK__Numbers__3BD0199314209315]" Table="[Numbers]" Schema="[dbo]" Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.000666306" AvgRowSize="21" EstimatedTotalSubtreeCost="0.522014" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[E]" Column="string"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></OuterReferences><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="159.403" EstimateIO="0" EstimateCPU="0.000666306" AvgRowSize="11" EstimatedTotalSubtreeCost="0.057768" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="4.8e-07" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0341891" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.3e-06" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0341886" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="MAX(CASE WHEN [Expr1003]=(1) THEN [Expr1001] ELSE NULL END)"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1001"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="MAX(CASE WHEN [Expr1003]=(2) THEN [Expr1001] ELSE NULL END)"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1001"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="MAX(CASE WHEN [Expr1003]=(3) THEN [Expr1001] ELSE NULL END)"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1001"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="2.4e-07" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0341863" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1001"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="3" EstimateIO="0" EstimateCPU="6e-08" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0341858" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1001"></ColumnReference><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Alias="[ETC]" Column="count"></ColumnReference><ColumnReference Column="Segment1014"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1014"></ColumnReference></SegmentColumn><RelOp NodeId="7" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="3" EstimateRowsWithoutRowGoal="3.81576" EstimateIO="0.0112613" EstimateCPU="0.00011152" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0341857" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1001"></ColumnReference><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Alias="[ETC]" Column="count"></ColumnReference></OutputList><MemoryFractions Input="0.2" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" 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="112" OutputMemoryGrant="112" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TopSort Distinct="0" Rows="3"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Alias="[ETC]" Column="count"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3.81576" EstimateRowsWithoutRowGoal="3.81576" EstimateIO="0" EstimateCPU="1.59499e-05" AvgRowSize="20" EstimatedTotalSubtreeCost="0.0228129" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1001"></ColumnReference><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Alias="[ETC]" Column="count"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1001"></ColumnReference></OuterReferences><RelOp NodeId="9" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="3.81576" EstimateIO="0.0112613" EstimateCPU="0.000111512" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0146651" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1001"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.8"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" 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="536" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1001"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3.81576" EstimateIO="0" EstimateCPU="3.81576e-07" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0032923" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1001"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1001"></ColumnReference><ScalarOperator ScalarString="substring(&apos;%BEEF%&apos;,[fiddle_d2dd5e62994e42d4a2d26257f974a379].[dbo].[Numbers].[n] as [n].[n],(3))"><Intrinsic FunctionName="substring"><ScalarOperator><Const ConstValue="&apos;%BEEF%&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Numbers]" Alias="[n]" Column="n"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="3.81576" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="18" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Numbers]" Alias="[n]" Column="n"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Numbers]" Alias="[n]" Column="n"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Numbers]" Index="[PK__Numbers__3BD0199314209315]" Alias="[n]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><EndRange ScanType="LE"><RangeColumns><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Numbers]" Alias="[n]" Column="n"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(4)"><Const ConstValue="(4)"></Const></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="NOT CONVERT(varchar(3),substring(&apos;%BEEF%&apos;,[fiddle_d2dd5e62994e42d4a2d26257f974a379].[dbo].[Numbers].[n] as [n].[n],(3)),0) like &apos;%[^A-Z0-9a-z]%&apos;"><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Convert DataType="varchar" Length="3" Style="0" Implicit="0"><ScalarOperator><Intrinsic FunctionName="substring"><ScalarOperator><Const ConstValue="&apos;%BEEF%&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Numbers]" Alias="[n]" Column="n"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%[^A-Z0-9a-z]%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Sort></RelOp><RelOp NodeId="12" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00813189" TableCardinality="4096" Parallel="0" EstimateRebinds="2.81576" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Alias="[ETC]" Column="count"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="0" ActualExecutions="2" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="1" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Alias="[ETC]" Column="count"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Index="[IX]" Alias="[ETC]" IndexKind="ViewClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[TrigramCount]" Alias="[ETC]" Column="trigram"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1001]"><Identifier><ColumnReference Column="Expr1001"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></TopSort></RelOp></Segment></RelOp></SequenceProject></RelOp></StreamAggregate></RelOp><Predicate><ScalarOperator ScalarString="[Expr1004] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="13" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="159.403" EstimateIO="0" EstimateCPU="0.00190553" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0229126" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="14" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="874.097" EstimateIO="0" EstimateCPU="0.00122536" AvgRowSize="19" EstimatedTotalSubtreeCost="0.021007" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="334" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="Union1010"></ColumnReference></GroupBy><RelOp NodeId="15" PhysicalOp="Merge Join" LogicalOp="Concatenation" EstimateRows="1313.85" EstimateIO="0" EstimateCPU="0.00424523" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0197817" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="343" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET3]" Column="id"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Merge Join" LogicalOp="Concatenation" EstimateRows="1313.85" EstimateIO="0" EstimateCPU="0.00424523" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0117727" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="343" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1010"></ColumnReference><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET1]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET2]" Column="id"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="437.948" EstimatedRowsRead="437.948" EstimateIO="0.003125" EstimateCPU="0.000638743" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00376374" TableCardinality="1.79384e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET1]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="168" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="168" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="1" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET1]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Index="[IX]" Alias="[ET1]" IndexKind="ViewClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET1]" Column="trigram"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="CONVERT_IMPLICIT(char(3),[Expr1004],0)"><Convert DataType="char" Length="3" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp><RelOp NodeId="18" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="437.948" EstimatedRowsRead="437.948" EstimateIO="0.003125" EstimateCPU="0.000638743" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00376374" TableCardinality="1.79384e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET2]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="175" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="175" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="1" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET2]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Index="[IX]" Alias="[ET2]" IndexKind="ViewClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET2]" Column="trigram"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="CONVERT_IMPLICIT(char(3),[Expr1005],0)"><Convert DataType="char" Length="3" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Merge></RelOp><RelOp NodeId="19" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="437.948" EstimatedRowsRead="437.948" EstimateIO="0.003125" EstimateCPU="0.000638743" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00376374" TableCardinality="1.79384e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET3]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="1" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET3]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Index="[IX]" Alias="[ET3]" IndexKind="ViewClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[ExampleTrigrams]" Alias="[ET3]" Column="trigram"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="CONVERT_IMPLICIT(char(3),[Expr1006],0)"><Convert DataType="char" Length="3" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></Merge></RelOp></StreamAggregate></RelOp><Predicate><ScalarOperator ScalarString="[Expr1011]=CONVERT_IMPLICIT(bigint,(1)+CASE WHEN CONVERT_IMPLICIT(char(3),[Expr1005],0) IS NULL THEN (0) ELSE (1) END+CASE WHEN CONVERT_IMPLICIT(char(3),[Expr1006],0) IS NULL THEN (0) ELSE (1) END,0)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="bigint" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Convert DataType="char" Length="3" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Convert DataType="char" Length="3" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Else></IF></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp><RelOp NodeId="20" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="21" EstimatedTotalSubtreeCost="0.463439" TableCardinality="100000" Parallel="0" EstimateRebinds="158.403" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[E]" Column="string"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="17" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="9" ActualEndOfScans="1" ActualExecutions="9" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[E]" Column="string"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Index="[PK dbo.Example (id)]" Alias="[E]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[E]" Column="id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Union1010]"><Identifier><ColumnReference Column="Union1010"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_d2dd5e62994e42d4a2d26257f974a379].[dbo].[Example].[string] as [E].[string] like &apos;%BEEF%&apos;"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d2dd5e62994e42d4a2d26257f974a379]" Schema="[dbo]" Table="[Example]" Alias="[E]" Column="string"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%BEEF%&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


Table 'Example'. Scan count 0, logical reads 32, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
Table 'ExampleTrigrams'. Scan count 2, logical reads 6, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
Table 'TrigramCount'. Scan count 0, logical reads 4, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
Table 'Numbers'. Scan count 1, logical reads 2, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.




ElapsedMS


15



 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 15 ms.