By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE #tmp_cohellation_fun
(
ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED
, myValue VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CS_AS
)
-- Garbage values to represent data you don't want
INSERT INTO #tmp_cohellation_fun
SELECT CAST(NEWID() AS VARCHAR(50))
FROM master.sys.configurations t1
CROSS JOIN master.sys.configurations t2
CROSS JOIN master.sys.configurations t3;
-- Sprinkle a little bit of good data
INSERT INTO #tmp_cohellation_fun
(myValue)
VALUES ('Apple')
, ('apple')
-- Another healthy helping of garbage that we don't care about
INSERT INTO #tmp_cohellation_fun
SELECT CAST(NEWID() AS VARCHAR(50))
FROM master.sys.configurations t1
CROSS JOIN master.sys.configurations t2
CROSS JOIN master.sys.configurations t3;
-- Some more good data
INSERT INTO #tmp_cohellation_fun
(myValue)
VALUES
('aPple')
, ('APPLE')
, ('APple')
-- Final insert of garbage that we don't care about
| ID | myValue |
|---|---|
| 438978 | apple |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3451.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT	*
FROM	#tmp_cohellation_fun
WHERE	myValue LIKE 'apple%'" StatementId="1" StatementCompId="9" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00331207" StatementEstRows="27.3336" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x573D53C74612EC4C" QueryPlanHash="0x0158D8C0E1EA6858" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="12" CompileCPU="12" CompileMemory="376"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1195056"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-08-31T10:54:12.45" ModificationCount="0" SamplingPercent="100" Statistics="[ix_myValue]" Table="[#tmp_cohellation_fun________________________________________________________________________________________________000000000832]" Schema="[dbo]" Database="[tempdb]"></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="Index Seek" LogicalOp="Index Seek" EstimateRows="27.3336" EstimatedRowsRead="27.3336" EstimateIO="0.003125" EstimateCPU="0.000187067" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00331207" TableCardinality="1.31693e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="ID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="5" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="ID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Index="[ix_myValue]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="'appldþ'"><Const ConstValue="'appldþ'"></Const></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="'applF'"><Const ConstValue="'applF'"></Const></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[tempdb].[dbo].[#tmp_cohellation_fun].[myValue] like 'apple%'"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="'apple%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
SELECT *
FROM #tmp_cohellation_fun
WHERE myValue LIKE 'apple%'
SELECT
SELECT
| Cached plan size | 16 KB |
|---|---|
| Estimated Operator Cost | 0 (0%) |
| Estimated Subtree Cost | 0.0033121 |
| Degree of Parallelism | 0 |
| Estimated Number of Rows | 27.3336 |
Statement
SELECT *
FROM #tmp_cohellation_fun
WHERE myValue LIKE 'apple%'
Index Seek (NonClustered)
[#tmp_cohellation_fun].[ix_myValue]
Cost: 100%
Index Seek (NonClustered)
Scan a particular range of rows from a nonclustered index.
| Physical Operation | Index Seek |
|---|---|
| Logical Operation | Index Seek |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Storage | RowStore |
| Number of Rows Read | 5 |
| Actual Number of Rows | 1 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0033121 (100%) |
| Estimated I/O Cost | 0.003125 |
| Estimated CPU Cost | 0.0001871 |
| Estimated Subtree Cost | 0.0033121 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows to be Read | 27.3336 |
| Estimated Number of Rows | 27.3336 |
| Estimated Row Size | 40 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Ordered | True |
| Node ID | 0 |
Output List
[tempdb].[dbo].[#tmp_cohellation_fun].ID
[tempdb].[dbo].[#tmp_cohellation_fun].myValue
Object
[tempdb].[dbo].[#tmp_cohellation_fun].[ix_myValue]
Seek Predicates
Seek Keys[1]: Start: [tempdb].[dbo].[#tmp_cohellation_fun].myValue >= Scalar Operator('appldþ'), End: [tempdb].[dbo].[#tmp_cohellation_fun].myValue < Scalar Operator('applF')
Predicate
[tempdb].[dbo].[#tmp_cohellation_fun].[myValue] like 'apple%'
| ID | myValue |
|---|---|
| 877956 | APPLE |
| 877957 | APple |
| 438977 | Apple |
| 877955 | aPple |
| 438978 | apple |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3451.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT	*
FROM	#tmp_cohellation_fun
WHERE	myValue COLLATE SQL_Latin1_General_CP1_CI_AS LIKE 'apple%'" StatementId="2" StatementCompId="10" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="7.64212" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xECCDA4375BEAF065" QueryPlanHash="0x572928C22EE2ADFE" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="256"><Warnings><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT(varchar(50),[tempdb].[dbo].[#tmp_cohellation_fun].[myValue],0)>='applDþ'"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1195056"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-08-31T10:54:12.45" ModificationCount="0" SamplingPercent="100" Statistics="[ix_myValue]" Table="[#tmp_cohellation_fun________________________________________________________________________________________________000000000832]" Schema="[dbo]" Database="[tempdb]"></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><WaitStats><Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="11" WaitCount="86"></Wait></WaitStats><QueryTimeStats ElapsedTime="359" CpuTime="347"></QueryTimeStats><RelOp NodeId="1" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1" EstimatedRowsRead="1.31693e+006" EstimateIO="6.06164" EstimateCPU="1.44878" AvgRowSize="50" EstimatedTotalSubtreeCost="7.51043" TableCardinality="1.31693e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="ID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="359" ActualCPUms="347" ActualScans="1" ActualLogicalReads="8238" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1316933" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="ID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Index="[ix_myValue]" IndexKind="NonClustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="CONVERT(varchar(50),[tempdb].[dbo].[#tmp_cohellation_fun].[myValue],0) like 'apple%'"><Intrinsic FunctionName="like"><ScalarOperator><Convert DataType="varchar" Length="50" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="'apple%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
SELECT *
FROM #tmp_cohellation_fun
WHERE myValue COLLATE SQL_Latin1_General_CP1_CI_AS LIKE 'apple%'
SELECT
SELECT
| Cached plan size | 16 KB |
|---|---|
| Estimated Operator Cost | 0 (0%) |
| Estimated Subtree Cost | 7.64212 |
| Degree of Parallelism | 0 |
| Estimated Number of Rows | 1 |
Statement
SELECT *
FROM #tmp_cohellation_fun
WHERE myValue COLLATE SQL_Latin1_General_CP1_CI_AS LIKE 'apple%'
Warnings
Type conversion in expression (CONVERT(varchar(50),[tempdb].[dbo].[#tmp_cohellation_fun].[myValue],0)>='applDþ') may affect "Seek Plan" in query plan choice.
Index Scan (NonClustered)
[#tmp_cohellation_fun].[ix_myValue]
Cost: 100%
Index Scan (NonClustered)
| Physical Operation | Index Scan |
|---|---|
| Logical Operation | Index Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Storage | RowStore |
| Number of Rows Read | 1316933 |
| Actual Number of Rows | 5 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 7.51043 (100%) |
| Estimated I/O Cost | 6.06164 |
| Estimated CPU Cost | 1.44878 |
| Estimated Subtree Cost | 7.51043 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows to be Read | 1.31693e+006 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 50 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Ordered | False |
| Node ID | 1 |
Output List
[tempdb].[dbo].[#tmp_cohellation_fun].ID
[tempdb].[dbo].[#tmp_cohellation_fun].myValue
Object
[tempdb].[dbo].[#tmp_cohellation_fun].[ix_myValue]
Predicate
CONVERT(varchar(50),[tempdb].[dbo].[#tmp_cohellation_fun].[myValue],0) like 'apple%'
| ID | myValue |
|---|---|
| 877956 | APPLE |
| 877957 | APple |
| 438977 | Apple |
| 877955 | aPple |
| 438978 | apple |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3451.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT	*
FROM	#tmp_cohellation_fun
WHERE	myValue LIKE '[aA][pP][pP][lL][eE]%'" StatementId="3" StatementCompId="11" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00331207" StatementEstRows="27.3336" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x573D53C74612EC4C" QueryPlanHash="0x0158D8C0E1EA6858" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="16" CompileCPU="16" CompileMemory="376"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1195056"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-08-31T10:54:12.45" ModificationCount="0" SamplingPercent="100" Statistics="[ix_myValue]" Table="[#tmp_cohellation_fun________________________________________________________________________________________________000000000832]" Schema="[dbo]" Database="[tempdb]"></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="32" CpuTime="32"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="27.3336" EstimatedRowsRead="27.3336" EstimateIO="0.003125" EstimateCPU="0.000187067" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00331207" TableCardinality="1.31693e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="ID"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="32" ActualCPUms="32" ActualScans="1" ActualLogicalReads="518" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="82079" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="ID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Index="[ix_myValue]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="'9þþþþþþþþþþþþþþþþþþþþ'"><Const ConstValue="'9þþþþþþþþþþþþþþþþþþþþ'"></Const></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="'B'"><Const ConstValue="'B'"></Const></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[tempdb].[dbo].[#tmp_cohellation_fun].[myValue] like '[aA][pP][pP][lL][eE]%'"><Intrinsic FunctionName="like"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tmp_cohellation_fun]" Column="myValue"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="'[aA][pP][pP][lL][eE]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Predicate></IndexScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
SELECT *
FROM #tmp_cohellation_fun
WHERE myValue LIKE '[aA][pP][pP][lL][eE]%'
SELECT
SELECT
| Cached plan size | 16 KB |
|---|---|
| Estimated Operator Cost | 0 (0%) |
| Estimated Subtree Cost | 0.0033121 |
| Degree of Parallelism | 0 |
| Estimated Number of Rows | 27.3336 |
Statement
SELECT *
FROM #tmp_cohellation_fun
WHERE myValue LIKE '[aA][pP][pP][lL][eE]%'
Index Seek (NonClustered)
[#tmp_cohellation_fun].[ix_myValue]
Cost: 100%
Index Seek (NonClustered)
Scan a particular range of rows from a nonclustered index.
| Physical Operation | Index Seek |
|---|---|
| Logical Operation | Index Seek |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Storage | RowStore |
| Number of Rows Read | 82079 |
| Actual Number of Rows | 5 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0033121 (100%) |
| Estimated I/O Cost | 0.003125 |
| Estimated CPU Cost | 0.0001871 |
| Estimated Subtree Cost | 0.0033121 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows to be Read | 27.3336 |
| Estimated Number of Rows | 27.3336 |
| Estimated Row Size | 40 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Ordered | True |
| Node ID | 0 |
Output List
[tempdb].[dbo].[#tmp_cohellation_fun].ID
[tempdb].[dbo].[#tmp_cohellation_fun].myValue
Object
[tempdb].[dbo].[#tmp_cohellation_fun].[ix_myValue]
Seek Predicates
Seek Keys[1]: Start: [tempdb].[dbo].[#tmp_cohellation_fun].myValue >= Scalar Operator('9þþþþþþþþþþþþþþþþþþþþ'), End: [tempdb].[dbo].[#tmp_cohellation_fun].myValue < Scalar Operator('B')
Predicate
[tempdb].[dbo].[#tmp_cohellation_fun].[myValue] like '[aA][pP][pP][lL][eE]%'