By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
id | account_id | account_value | f_name | l_name | creation_date | last_login | changed |
---|---|---|---|---|---|---|---|
10 | 1010 | 10000.0000 | Huevos | Rancheros | 2024-10-01 00:00:00.000 | 2024-10-07 00:00:00.000 | Unchanged |
9 | 1009 | 9000.0000 | Shak | Shuka | 2024-09-01 00:00:00.000 | 2024-09-07 00:00:00.000 | Unchanged |
8 | 1008 | 8000.0000 | French | Toast | 2024-08-01 00:00:00.000 | 2024-08-07 00:00:00.000 | Deleted, re-inserted with different values |
7 | 1007 | 7000.0000 | Quiche | Lorraine | 2024-07-01 00:00:00.000 | 2024-07-07 00:00:00.000 | Account value set to 5001 (initial blocker) |
6 | 1006 | 6000.0000 | Scotch | Egg | 2024-06-01 00:00:00.000 | 2024-06-07 00:00:00.000 | Account value doubled to 12,000 |
5 | 1005 | 5000.0000 | Bloody | Mary | 2024-05-01 00:00:00.000 | 2024-05-07 00:00:00.000 | Deleted entirely |
4 | 1004 | 4000.0000 | Duck | Hash | 2024-04-01 00:00:00.000 | 2024-04-07 00:00:00.000 | Account value set to 999 |
3 | 1003 | 3000.0000 | Chefs | Omelette | 2024-03-01 00:00:00.000 | 2024-03-07 00:00:00.000 | Account value set to 999 |
2 | 1002 | 2000.0000 | Steak | Frites | 2024-02-01 00:00:00.000 | 2024-02-07 00:00:00.000 | Deleted, re-inserted with different values |
1 | 1001 | 1000.0000 | Eggs | Benedict | 2024-01-01 00:00:00.000 | 2024-01-07 00:00:00.000 | Account value set to 999 |
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 [rcs].*,case [rcs].[id] when (1) then 'Account value set to 999' when (2) then 'Deleted, re-inserted with different values' when (3) then 'Account value set to 999' when (4) then 'Account value set to 999' when (5) then 'Deleted entirely' when (6) then 'Account value doubled to 12,000' when (7) then 'Account value set to 5001 (initial blocker)' when (8) then 'Deleted, re-inserted with different values' when (9) then 'Unchanged' when (10) then 'Unchanged' end [changed] FROM [dbo].[ReadCommittedStinks] [rcs] WHERE [rcs].[account_value]>=CONVERT([money],@1) ORDER BY [rcs].[account_value] DESC" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x090052F625CFDB1CA0B0FD865822C92124570000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="0.014712" StatementEstRows="10" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x6F03EF186449B398" QueryPlanHash="0x1B252D4A5B00764A" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" 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="40" CompileTime="0" CompileCPU="0" CompileMemory="336"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="746544" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1396928"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-04-24T11:37:15.26" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_35BCFE0A]" Table="[ReadCommittedStinks]" Schema="[dbo]" Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]"></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="16" CpuTime="16"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="10" EstimateIO="0" EstimateCPU="4.8e-06" AvgRowSize="102" EstimatedTotalSubtreeCost="0.014712" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference><ColumnReference Column="Expr1001"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="10" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="102" EstimatedTotalSubtreeCost="0.0147072" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference><ColumnReference Column="Expr1001"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1001"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(1) THEN 'Account value set to 999' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(2) THEN 'Deleted, re-inserted with different values' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(3) THEN 'Account value set to 999' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(4) THEN 'Account value set to 999' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(5) THEN 'Deleted entirely' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(6) THEN 'Account value doubled to 12,000' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(7) THEN 'Account value set to 5001 (initial blocker)' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(8) THEN 'Deleted, re-inserted with different values' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(9) THEN 'Unchanged' ELSE CASE WHEN [fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[id] as [rcs].[id]=(10) THEN 'Unchanged' ELSE NULL END END END END END END END END END END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Account value set to 999'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Deleted, re-inserted with different values'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Account value set to 999'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Account value set to 999'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Deleted entirely'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Account value doubled to 12,000'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(7)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Account value set to 5001 (initial blocker)'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Deleted, re-inserted with different values'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(9)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Unchanged'"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="'Unchanged'"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="10" EstimateIO="0.0112613" EstimateCPU="0.000151901" AvgRowSize="79" EstimatedTotalSubtreeCost="0.0147062" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" 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="640" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="10" EstimatedRowsRead="10" EstimateIO="0.003125" EstimateCPU="0.000168" AvgRowSize="79" EstimatedTotalSubtreeCost="0.003293" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="10" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Index="[PK__ReadComm__3213E83F21CF7829]" Alias="[rcs]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Sort></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[account_value] as [rcs].[account_value]>=($1000.0000)"><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="($1000.0000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp><ParameterList><ColumnReference Column="@1" ParameterDataType="numeric(6,2)" ParameterCompiledValue="(1000.00)" ParameterRuntimeValue="(1000.00)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
id | account_id | account_value | f_name | l_name | creation_date | last_login |
---|---|---|---|---|---|---|
10 | 1010 | 10000.0000 | Huevos | Rancheros | 2024-10-01 00:00:00.000 | 2024-10-07 00:00:00.000 |
9 | 1009 | 9000.0000 | Shak | Shuka | 2024-09-01 00:00:00.000 | 2024-09-07 00:00:00.000 |
8 | 1008 | 8000.0000 | French | Toast | 2024-08-01 00:00:00.000 | 2024-08-07 00:00:00.000 |
7 | 1007 | 7000.0000 | Quiche | Lorraine | 2024-07-01 00:00:00.000 | 2024-07-07 00:00:00.000 |
6 | 1006 | 6000.0000 | Scotch | Egg | 2024-06-01 00:00:00.000 | 2024-06-07 00:00:00.000 |
5 | 1005 | 5000.0000 | Bloody | Mary | 2024-05-01 00:00:00.000 | 2024-05-07 00:00:00.000 |
4 | 1004 | 4000.0000 | Duck | Hash | 2024-04-01 00:00:00.000 | 2024-04-07 00:00:00.000 |
3 | 1003 | 3000.0000 | Chefs | Omelette | 2024-03-01 00:00:00.000 | 2024-03-07 00:00:00.000 |
2 | 1002 | 2000.0000 | Steak | Frites | 2024-02-01 00:00:00.000 | 2024-02-07 00:00:00.000 |
1 | 1001 | 1000.0000 | Eggs | Benedict | 2024-01-01 00:00:00.000 | 2024-01-07 00:00: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 [rcs].* FROM [dbo].[ReadCommittedStinks] [rcs] WHERE [rcs].[account_value]>=CONVERT([money],@1) ORDER BY [rcs].[account_value] DESC" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x090081654B655DE68306FE26F05E7403E8230000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="0.014711" StatementEstRows="10" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE7AF1012436F1B04" QueryPlanHash="0x8027E93BF9DC6865" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" 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="32" CompileTime="0" CompileCPU="0" CompileMemory="168"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="746544" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1396928"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-04-24T11:37:15.26" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_35BCFE0A]" Table="[ReadCommittedStinks]" Schema="[dbo]" Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]"></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="Sort" LogicalOp="Sort" EstimateRows="10" EstimateIO="0.0112613" EstimateCPU="0.000151901" AvgRowSize="79" EstimatedTotalSubtreeCost="0.014711" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" 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="640" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="10" EstimatedRowsRead="10" EstimateIO="0.003125" EstimateCPU="0.000168" AvgRowSize="79" EstimatedTotalSubtreeCost="0.003293" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="10" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="f_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="l_name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="creation_date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="last_login"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Index="[PK__ReadComm__3213E83F21CF7829]" Alias="[rcs]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_4d4a780e77274e0b906f6a98747e37a1].[dbo].[ReadCommittedStinks].[account_value] as [rcs].[account_value]>=($1000.0000)"><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_4d4a780e77274e0b906f6a98747e37a1]" Schema="[dbo]" Table="[ReadCommittedStinks]" Alias="[rcs]" Column="account_value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="($1000.0000)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Sort></RelOp><ParameterList><ColumnReference Column="@1" ParameterDataType="numeric(6,2)" ParameterCompiledValue="(1000.00)" ParameterRuntimeValue="(1000.00)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |