add batch remove batch split batch comment selection show hidden batches hide batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
100000 rows affected
Id CreatedDate
99991 2020-03-10 10:31:00.000
99992 2020-03-10 10:32:00.000
99993 2020-03-10 10:33:00.000
99994 2020-03-10 10:34:00.000
99995 2020-03-10 10:35:00.000
99996 2020-03-10 10:36:00.000
99997 2020-03-10 10:37:00.000
99998 2020-03-10 10:38:00.000
99999 2020-03-10 10:39:00.000
100000 2020-03-10 10:40:00.000
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 * FROM [TestMessages] WHERE [CreatedDate]&gt;@1" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x09003EFE62C44FF829CEE6685B0B76BF75010000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="2" RetrievedFromCache="true" StatementSubTreeCost="0.433282" StatementEstRows="10.9998" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x468140CFC78A81CC" QueryPlanHash="0x2DFAA72F2FA57F48" 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="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="24" CompileTime="62" CompileCPU="62" CompileMemory="128"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1624704"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-01-07T13:03:46.16" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_35BCFE0A]" Table="[TestMessages]" Schema="[dbo]" Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]"></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="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="10.9998" EstimatedRowsRead="100000" EstimateIO="0.323125" EstimateCPU="0.110157" AvgRowSize="19" EstimatedTotalSubtreeCost="0.433282" TableCardinality="100000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="CreatedDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="435" 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_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="CreatedDate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Index="[PK__TestMess__3214EC0742F5B709]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f].[dbo].[TestMessages].[CreatedDate]&gt;CONVERT_IMPLICIT(datetime,[@1],0)"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="CreatedDate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><ParameterList><ColumnReference Column="@1" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;2020-03-10 10:30:00.000&apos;" ParameterRuntimeValue="&apos;2020-03-10 10:30:00.000&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Id CreatedDate
99991 2020-03-10 10:31:00.000
99992 2020-03-10 10:32:00.000
99993 2020-03-10 10:33:00.000
99994 2020-03-10 10:34:00.000
99995 2020-03-10 10:35:00.000
99996 2020-03-10 10:36:00.000
99997 2020-03-10 10:37:00.000
99998 2020-03-10 10:38:00.000
99999 2020-03-10 10:39:00.000
100000 2020-03-10 10:40:00.000
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 * &#xa;FROM TestMessages&#xa;WHERE CreatedDate &gt; @ConvertedDate" StatementId="1" StatementCompId="3" StatementType="SELECT" StatementSqlHandle="0x0900E76EB5ADE5D711FAD8131223AB693AAF0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.433282" StatementEstRows="30000" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x468140CFC78A81CC" QueryPlanHash="0x2DFAA72F2FA57F48" 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="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="136"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1624704"></OptimizerHardwareDependentProperties><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="15" CpuTime="15"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="30000" EstimatedRowsRead="100000" EstimateIO="0.323125" EstimateCPU="0.110157" AvgRowSize="19" EstimatedTotalSubtreeCost="0.433282" TableCardinality="100000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="Id"></ColumnReference><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="CreatedDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualElapsedms="15" ActualCPUms="15" ActualScans="1" ActualLogicalReads="435" 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_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="CreatedDate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Index="[PK__TestMess__3214EC0742F5B709]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f].[dbo].[TestMessages].[CreatedDate]&gt;[@ConvertedDate]"><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_2a21a89dedbc4bd38d28fd46e7addb7f]" Schema="[dbo]" Table="[TestMessages]" Column="CreatedDate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@ConvertedDate"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><ParameterList><ColumnReference Column="@ConvertedDate" ParameterDataType="datetime" ParameterRuntimeValue="&apos;2020-03-10 10:30:00.000&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>