| 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 @C =
 COUNT_BIG(DISTINCT col1)
FROM dbo.SeekTest AS ST WITH (INDEX(ix))" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x090064D97B1B5A7CC5DEEEB78DF2783B12710000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.451057" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xAED1A81C695092D5" QueryPlanHash="0xC85F58B9421F92D7" 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" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="88" CompileCPU="72" CompileMemory="184"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1847168"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-09-11T04:45:30.30" ModificationCount="0" SamplingPercent="100" Statistics="[cx]" Table="[SeekTest]" Schema="[dbo]" Database="[fiddle_5b20c1130bfc470ea59e23e02eab5e3d]"></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="36" CpuTime="36"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0511109" AvgRowSize="15" EstimatedTotalSubtreeCost="0.451057" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="36" ActualCPUms="36" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="85184" EstimateIO="0" EstimateCPU="0.085184" AvgRowSize="15" EstimatedTotalSubtreeCost="0.399946" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5b20c1130bfc470ea59e23e02eab5e3d]" Schema="[dbo]" Table="[SeekTest]" Alias="[ST]" Column="col1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="85184" Batches="0" ActualElapsedms="36" ActualCPUms="36" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues></DefinedValues><GroupBy><ColumnReference Database="[fiddle_5b20c1130bfc470ea59e23e02eab5e3d]" Schema="[dbo]" Table="[SeekTest]" Alias="[ST]" Column="col1"></ColumnReference></GroupBy><RelOp NodeId="2" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="85184" EstimatedRowsRead="85184" EstimateIO="0.220903" EstimateCPU="0.0938594" AvgRowSize="15" EstimatedTotalSubtreeCost="0.314762" TableCardinality="85184" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5b20c1130bfc470ea59e23e02eab5e3d]" Schema="[dbo]" Table="[SeekTest]" Alias="[ST]" Column="col1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="85184" Batches="0" ActualElapsedms="36" ActualCPUms="36" ActualScans="1" ActualLogicalReads="297" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="85184" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="1" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_5b20c1130bfc470ea59e23e02eab5e3d]" Schema="[dbo]" Table="[SeekTest]" Alias="[ST]" Column="col1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_5b20c1130bfc470ea59e23e02eab5e3d]" Schema="[dbo]" Table="[SeekTest]" Index="[ix]" Alias="[ST]" IndexKind="NonClustered" Storage="RowStore"></Object></IndexScan></RelOp></StreamAggregate></RelOp></StreamAggregate></RelOp><ParameterList><ColumnReference Column="@C" ParameterDataType="bigint" ParameterRuntimeValue="(85184)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
Table 'SeekTest'. Scan count 1, logical reads 297, 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.