By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| RecordID | GroupIdentifier | Hash | GroupHashList |
|---|---|---|---|
| 1 | 1 | 73F294873462B2BA0E930FD16DCCB7 | null |
| 2 | 1 | 90E749375DF806CB6E3F5CA48FFA38 | null |
| 3 | 1 | E44256CE7CFCB971EB679BAC25A697 | null |
| 4 | 2 | 73F294873462B2BA0E930FD16DCCB7 | null |
| 5 | 2 | E44256CE7CFCB971EB679BAC25A697 | null |
| 6 | 2 | 90E749375DF806CB6E3F5CA48FFA38 | null |
| (No column name) |
|---|
| 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4223.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT STRING_AGG([Hash],';') WITHIN GROUP (ORDER BY [Hash] ASC)
FROM HashTable
GROUP BY [GroupIdentifier]" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0146787" StatementEstRows="2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xD12534EDAEAF4267" QueryPlanHash="0xAF979A39E61E5B04" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><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="24" CompileTime="15" CompileCPU="0" CompileMemory="136"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="755448" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1308552"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-02-05T16:59:07.95" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[HashTable]" Schema="[dbo]" Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]"></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="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="4.6e-06" AvgRowSize="4011" EstimatedTotalSubtreeCost="0.0146787" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[Hash],';')WITHIN GROUP (ORDER BY [fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[Hash])"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="Hash"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="';'"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="GroupIdentifier"></ColumnReference></GroupBy><RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="6" EstimateIO="0.0112613" EstimateCPU="0.000124235" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0146741" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="Hash"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" 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"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="GroupIdentifier"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="Hash"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="2" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="GroupIdentifier"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Column="Hash"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Sort></RelOp></StreamAggregate></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
| RecordID | GroupIdentifier | Hash | GroupHashList |
|---|---|---|---|
| 1 | 1 | 73F294873462B2BA0E930FD16DCCB7 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 2 | 1 | 90E749375DF806CB6E3F5CA48FFA38 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 3 | 1 | E44256CE7CFCB971EB679BAC25A697 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 4 | 2 | 73F294873462B2BA0E930FD16DCCB7 | 73F294873462B2BA0E930FD16DCCB7;E44256CE7CFCB971EB679BAC25A697;90E749375DF806CB6E3F5CA48FFA38 |
| 5 | 2 | E44256CE7CFCB971EB679BAC25A697 | 73F294873462B2BA0E930FD16DCCB7;E44256CE7CFCB971EB679BAC25A697;90E749375DF806CB6E3F5CA48FFA38 |
| 6 | 2 | 90E749375DF806CB6E3F5CA48FFA38 | 73F294873462B2BA0E930FD16DCCB7;E44256CE7CFCB971EB679BAC25A697;90E749375DF806CB6E3F5CA48FFA38 |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4223.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE HT1
SET GroupHashList = C.HashList
OUTPUT inserted.*
FROM HashTable AS HT1
JOIN
(
 SELECT
 GroupIdentifier,
 HashList =
 STRING_AGG(HT2.[Hash], ';')
 WITHIN GROUP (ORDER BY HT2.[Hash] ASC)
 FROM HashTable AS HT2
 GROUP BY
 HT2.GroupIdentifier
) AS C
 ON C.GroupIdentifier = HT1.GroupIdentifier" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="true" StatementSubTreeCost="0.024815" StatementEstRows="6" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xCB8EF70E140D549F" QueryPlanHash="0x7E717C5F20DED669" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><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="CouldNotGenerateValidParallelPlan" CachedPlanSize="48" CompileTime="0" CompileCPU="0" CompileMemory="360"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="755448" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1308552"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-02-05T16:59:07.95" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[HashTable]" Schema="[dbo]" Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]"></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="1" PhysicalOp="Table Update" LogicalOp="Update" EstimateRows="6" EstimateIO="0.01" EstimateCPU="6e-06" AvgRowSize="121" EstimatedTotalSubtreeCost="0.024815" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="RecordID"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupHashList"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" IndexKind="Heap" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[GroupHashList] as [HT1].[GroupHashList] = [Expr1005]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupHashList"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="6" EstimateIO="0" EstimateCPU="6e-07" AvgRowSize="94" EstimatedTotalSubtreeCost="0.014809" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(150),[Expr1004],0)"><Convert DataType="varchar" Length="150" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="6" EstimateIO="0" EstimateCPU="0.000101209" AvgRowSize="4019" EstimatedTotalSubtreeCost="0.0148084" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="5" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0147033" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="13" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Spool><RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="6" EstimateIO="0" EstimateCPU="1.3144e-05" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0146901" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference><ColumnReference Column="Segment1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1009"></ColumnReference></SegmentColumn><RelOp NodeId="7" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="6" EstimateIO="0.0112613" EstimateCPU="0.000124243" AvgRowSize="48" EstimatedTotalSubtreeCost="0.014677" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" 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"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="8" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="1" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Column="Bmk1000"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" IndexKind="Heap" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[GroupIdentifier] as [HT1].[GroupIdentifier] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></TableScan></RelOp></Sort></RelOp></Segment></RelOp></Spool></RelOp><RelOp NodeId="9" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.3144e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="2.6288e-06" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Predicate><RelOp NodeId="10" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.3144e-06" AvgRowSize="48" EstimatedTotalSubtreeCost="1.3144e-06" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[Hash] as [HT1].[Hash],';')WITHIN GROUP (ORDER BY [HT2].[Hash])"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="';'"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="3" EstimateIO="0" EstimateCPU="0" AvgRowSize="48" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="2" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="5"></Spool></RelOp></StreamAggregate></RelOp><RelOp NodeId="12" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="3" EstimateIO="0" EstimateCPU="0" AvgRowSize="48" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="2" ActualEndOfScans="2" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="5"></Spool></RelOp></NestedLoops></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
| RecordID | GroupIdentifier | Hash | GroupHashList |
|---|---|---|---|
| 1 | 1 | 73F294873462B2BA0E930FD16DCCB7 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 2 | 1 | 90E749375DF806CB6E3F5CA48FFA38 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 3 | 1 | E44256CE7CFCB971EB679BAC25A697 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 4 | 2 | 73F294873462B2BA0E930FD16DCCB7 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 5 | 2 | E44256CE7CFCB971EB679BAC25A697 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| 6 | 2 | 90E749375DF806CB6E3F5CA48FFA38 | 73F294873462B2BA0E930FD16DCCB7;90E749375DF806CB6E3F5CA48FFA38;E44256CE7CFCB971EB679BAC25A697 |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4223.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE HT1
SET GroupHashList = C.HashList
OUTPUT inserted.*
FROM HashTable AS HT1
OUTER APPLY
(
 SELECT
 HashList =
 STRING_AGG(HT2.[Hash], ';')
 WITHIN GROUP (ORDER BY HT2.[Hash] ASC)
 FROM HashTable AS HT2
 WHERE HT2.GroupIdentifier = HT1.GroupIdentifier
) C" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="true" StatementSubTreeCost="0.0549862" StatementEstRows="6" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x2370D15823297FE5" QueryPlanHash="0x4AE94329DD2CFAD1" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><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="CouldNotGenerateValidParallelPlan" CachedPlanSize="48" CompileTime="15" CompileCPU="15" CompileMemory="360"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="755448" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1308552"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-02-05T16:59:07.95" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_22AA2996]" Table="[HashTable]" Schema="[dbo]" Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]"></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="1" PhysicalOp="Table Update" LogicalOp="Update" EstimateRows="6" EstimateIO="0.01" EstimateCPU="6e-06" AvgRowSize="121" EstimatedTotalSubtreeCost="0.0549862" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="RecordID"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="Hash"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupHashList"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" IndexKind="Heap" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[GroupHashList] as [HT1].[GroupHashList] = [Expr1006]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupHashList"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="2" PhysicalOp="Table Spool" LogicalOp="Eager Spool" EstimateRows="6" EstimateIO="0.013125" EstimateCPU="0.00010236" AvgRowSize="94" EstimatedTotalSubtreeCost="0.0449802" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="15" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Spool><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="6" EstimateIO="0" EstimateCPU="6e-07" AvgRowSize="94" EstimatedTotalSubtreeCost="0.0317528" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(150),[Expr1005],0)"><Convert DataType="varchar" Length="150" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="6" EstimateIO="0" EstimateCPU="2.508e-05" AvgRowSize="4019" EstimatedTotalSubtreeCost="0.0317522" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></OuterReferences><RelOp NodeId="5" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Bmk1000"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="1" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Column="Bmk1000"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4011" EstimatedTotalSubtreeCost="0.0284385" Parallel="0" EstimateRebinds="3" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.3e-06" AvgRowSize="4011" EstimatedTotalSubtreeCost="0.0284379" Parallel="0" EstimateRebinds="3" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="6"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[Hash] as [HT2].[Hash],';')WITHIN GROUP (ORDER BY [HT2].[Hash])"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="Hash"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="';'"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="3" EstimateIO="0" EstimateCPU="2.88e-06" AvgRowSize="36" EstimatedTotalSubtreeCost="0.0284241" Parallel="0" EstimateRebinds="3" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="18" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="6" ActualExecutions="6"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="9" PhysicalOp="Table Spool" LogicalOp="Eager Spool" EstimateRows="6" EstimateIO="0.013125" EstimateCPU="0.00010236" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0284069" Parallel="0" EstimateRebinds="0" EstimateRewinds="5" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="36" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="25" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="36" ActualRebinds="1" ActualRewinds="5" ActualEndOfScans="6" ActualExecutions="6"></RunTimeCountersPerThread></RunTimeInformation><Spool><RelOp NodeId="10" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="6" EstimateIO="0.0112613" EstimateCPU="0.000124235" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0146741" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="Hash"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" 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"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="Hash"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="11" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="6" EstimatedRowsRead="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="40" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="GroupIdentifier"></ColumnReference><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="Hash"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="GroupIdentifier"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="Hash"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Sort></RelOp></Spool></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[GroupIdentifier] as [HT2].[GroupIdentifier]=[fiddle_43d4c4e72aeb4329a39f0edba1006dc2].[dbo].[HashTable].[GroupIdentifier] as [HT1].[GroupIdentifier]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT2]" Column="GroupIdentifier"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_43d4c4e72aeb4329a39f0edba1006dc2]" Schema="[dbo]" Table="[HashTable]" Alias="[HT1]" Column="GroupIdentifier"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Spool></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |