add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected

1 rows affected
Salary
1
2
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select distinct Salary from Employees 1 1 0 null null null null 2 null null null 0.01464859 null null SELECT False null
2 1   |--Sort(DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC)) 1 2 1 Sort Distinct Sort DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC) null 2 0.01126126 0.000103131 11 0.01464859 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
2 1        |--Table Scan(OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees])) 1 3 2 Table Scan Table Scan OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees]) [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] 2 0.003125 0.0001592 11 0.0032842 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
Salary
1
2
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select Salary from Employees group by Salary 1 1 0 null null null null 2 null null null 0.01464859 null null SELECT False null
2 1   |--Sort(DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC)) 1 2 1 Sort Distinct Sort DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC) null 2 0.01126126 0.000103131 11 0.01464859 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
2 1        |--Table Scan(OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees])) 1 3 2 Table Scan Table Scan OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees]) [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] 2 0.003125 0.0001592 11 0.0032842 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
Salary
1
2
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select distinct Salary from Employees
option (order group)		 1 1 0 null null null null 2 null null null 0.01464859 null null SELECT False null
2 1   |--Sort(DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC)) 1 2 1 Sort Distinct Sort DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC) null 2 0.01126126 0.000103131 11 0.01464859 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
2 1        |--Table Scan(OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees])) 1 3 2 Table Scan Table Scan OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees]) [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] 2 0.003125 0.0001592 11 0.0032842 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
Salary
1
2
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select Salary from Employees group by Salary
option (order group)		 1 1 0 null null null null 2 null null null 0.01464859 null null SELECT False null
2 1   |--Sort(DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC)) 1 2 1 Sort Distinct Sort DISTINCT ORDER BY:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] ASC) null 2 0.01126126 0.000103131 11 0.01464859 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
2 1        |--Table Scan(OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees])) 1 3 2 Table Scan Table Scan OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees]) [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] 2 0.003125 0.0001592 11 0.0032842 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
Salary
1
2
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select distinct Salary from Employees
option (hash group)		 1 1 0 null null null null 2 null null null 0.02107732 null null SELECT False null
2 1   |--Hash Match(Aggregate, HASH:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary]), RESIDUAL:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] = [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary])) 1 2 1 Hash Match Aggregate HASH:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary]), RESIDUAL:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] = [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary]) null 2 0 0.01779312 11 0.02107732 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
2 1        |--Table Scan(OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees])) 1 3 2 Table Scan Table Scan OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees]) [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] 2 0.003125 0.0001592 11 0.0032842 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
Salary
1
2
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select Salary from Employees group by Salary
option (hash group)		 1 1 0 null null null null 2 null null null 0.02107732 null null SELECT False null
2 1   |--Hash Match(Aggregate, HASH:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary]), RESIDUAL:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] = [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary])) 1 2 1 Hash Match Aggregate HASH:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary]), RESIDUAL:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] = [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary]) null 2 0 0.01779312 11 0.02107732 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1
2 1        |--Table Scan(OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees])) 1 3 2 Table Scan Table Scan OBJECT:([fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees]) [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] 2 0.003125 0.0001592 11 0.0032842 [fiddle_9f0b277ce95a433e97a00c86e2c14029].[dbo].[Employees].[Salary] null PLAN_ROW False 1