clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 497159 fiddles created (9387 in the last week).

CREATE TABLE dbo.MyTable ( ColumnA varchar(22) COLLATE Latin1_General_CI_AS NOT NULL );
 hidden batch(es)


INSERT dbo.MyTable WITH (TABLOCKX) (ColumnA) SELECT TOP (1000) REPLICATE(CHAR(65 + ROW_NUMBER() OVER (ORDER BY @@SPID) % 26), 22) FROM master.sys.all_columns AS AC1 CROSS JOIN master.sys.all_columns AS AC2;
1000 rows affected
 hidden batch(es)


CREATE INDEX IX_MyIndex_A ON dbo.MyTable(ColumnA);
 hidden batch(es)


set statistics xml on; DECLARE @varA nvarchar(22) = N'a'; SELECT MT.ColumnA FROM dbo.MyTable AS MT WHERE MT.ColumnA = @varA;
ColumnA
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3045.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT MT.ColumnA &#xd;&#xa;FROM dbo.MyTable AS MT &#xd;&#xa;WHERE MT.ColumnA = @varA" StatementId="1" StatementCompId="3" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00332431" StatementEstRows="38.4615" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x6B48C045D2E7C11D" QueryPlanHash="0x2B872A4500903196" 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="24" CompileTime="0" CompileCPU="0" CompileMemory="136"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="614808"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2019-06-22T12:23:33.01" ModificationCount="0" SamplingPercent="100" Statistics="[IX_MyIndex_A]" Table="[MyTable]" Schema="[dbo]" Database="[fiddle_c61763b207974bee84e4441ac8649938]"></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="38.4615" EstimatedRowsRead="38.4615" EstimateIO="0.003125" EstimateCPU="0.000199308" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00332431" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></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 Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="39" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ValueVector><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></ValueVector><ScalarOperator ScalarString="GetRangeThroughConvert([@varA],[@varA],(62))"><Intrinsic FunctionName="GetRangeThroughConvert"><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(62)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" 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="3" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="38.4615" EstimatedRowsRead="38.4615" EstimateIO="0.003125" EstimateCPU="0.000199308" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00332431" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="38" 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="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Index="[IX_MyIndex_A]" Alias="[MT]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(22),[fiddle_c61763b207974bee84e4441ac8649938].[dbo].[MyTable].[ColumnA] as [MT].[ColumnA],0)=[@varA]"><Compare CompareOp="EQ"><ScalarOperator><Convert DataType="nvarchar" Length="44" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><ParameterList><ColumnReference Column="@varA" ParameterDataType="nvarchar(22)" ParameterRuntimeValue="N&apos;a&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
 hidden batch(es)


DECLARE @varA nvarchar(22) = N''; -- empty string SELECT MT.ColumnA FROM dbo.MyTable AS MT WHERE MT.ColumnA = @varA;
ColumnA
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3045.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT MT.ColumnA &#xd;&#xa;FROM dbo.MyTable AS MT &#xd;&#xa;WHERE MT.ColumnA = @varA" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00332431" StatementEstRows="38.4615" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x6B48C045D2E7C11D" QueryPlanHash="0x2B872A4500903196" 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="24" CompileTime="0" CompileCPU="0" CompileMemory="136"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="614808"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2019-06-22T12:23:33.01" ModificationCount="0" SamplingPercent="100" Statistics="[IX_MyIndex_A]" Table="[MyTable]" Schema="[dbo]" Database="[fiddle_c61763b207974bee84e4441ac8649938]"></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="38.4615" EstimatedRowsRead="38.4615" EstimateIO="0.003125" EstimateCPU="0.000199308" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00332431" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></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 Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="39" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ValueVector><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></ValueVector><ScalarOperator ScalarString="GetRangeThroughConvert([@varA],[@varA],(62))"><Intrinsic FunctionName="GetRangeThroughConvert"><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(62)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" 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="3" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="38.4615" EstimatedRowsRead="38.4615" EstimateIO="0.003125" EstimateCPU="0.000199308" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00332431" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1000" 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="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Index="[IX_MyIndex_A]" Alias="[MT]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(22),[fiddle_c61763b207974bee84e4441ac8649938].[dbo].[MyTable].[ColumnA] as [MT].[ColumnA],0)=[@varA]"><Compare CompareOp="EQ"><ScalarOperator><Convert DataType="nvarchar" Length="44" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><ParameterList><ColumnReference Column="@varA" ParameterDataType="nvarchar(22)" ParameterRuntimeValue="N&apos;&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
 hidden batch(es)


DECLARE @varA nvarchar(22) = N' '; -- single space SELECT MT.ColumnA FROM dbo.MyTable AS MT WHERE MT.ColumnA = @varA;
ColumnA
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3045.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT MT.ColumnA &#xd;&#xa;FROM dbo.MyTable AS MT &#xd;&#xa;WHERE MT.ColumnA = @varA" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.00332431" StatementEstRows="38.4615" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x6B48C045D2E7C11D" QueryPlanHash="0x2B872A4500903196" 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="24" CompileTime="0" CompileCPU="0" CompileMemory="136"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="614808"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2019-06-22T12:23:33.01" ModificationCount="0" SamplingPercent="100" Statistics="[IX_MyIndex_A]" Table="[MyTable]" Schema="[dbo]" Database="[fiddle_c61763b207974bee84e4441ac8649938]"></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="38.4615" EstimatedRowsRead="38.4615" EstimateIO="0.003125" EstimateCPU="0.000199308" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00332431" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></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 Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="39" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ValueVector><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></ValueVector><ScalarOperator ScalarString="GetRangeThroughConvert([@varA],[@varA],(62))"><Intrinsic FunctionName="GetRangeThroughConvert"><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(62)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" 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="3" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="38.4615" EstimatedRowsRead="38.4615" EstimateIO="0.003125" EstimateCPU="0.000199308" AvgRowSize="33" EstimatedTotalSubtreeCost="0.00332431" TableCardinality="1000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" 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="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Index="[IX_MyIndex_A]" Alias="[MT]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(22),[fiddle_c61763b207974bee84e4441ac8649938].[dbo].[MyTable].[ColumnA] as [MT].[ColumnA],0)=[@varA]"><Compare CompareOp="EQ"><ScalarOperator><Convert DataType="nvarchar" Length="44" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c61763b207974bee84e4441ac8649938]" Schema="[dbo]" Table="[MyTable]" Alias="[MT]" Column="ColumnA"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@varA"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp><ParameterList><ColumnReference Column="@varA" ParameterDataType="nvarchar(22)" ParameterRuntimeValue="N&apos; &apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
 hidden batch(es)