By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| (No column name) |
|---|
| a |
| a |
| Rows | Executes | StmtText | StmtId | NodeId | Parent | PhysicalOp | LogicalOp | Argument | DefinedValues | EstimateRows | EstimateIO | EstimateCPU | AvgRowSize | TotalSubtreeCost | OutputList | Warnings | Type | Parallel | EstimateExecutions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 1 | select @v1 union all select @v2 |
1 | 1 | 0 | null | null | null | null | 2 | null | null | null | 2.157E-06 | null | null | SELECT | False | null |
| 2 | 1 | |--Constant Scan(VALUES:((CONVERT_IMPLICIT(varchar(max),[@v1],0)),([@v2]))) | 1 | 2 | 1 | Constant Scan | Constant Scan | VALUES:((CONVERT_IMPLICIT(varchar(max),[@v1],0)),([@v2])) | null | 2 | 0 | 2.157E-06 | 4035 | 2.157E-06 | [Union1001] | null | PLAN_ROW | False | 1 |
| (No column name) |
|---|
| a |
| a |
| Rows | Executes | StmtText | StmtId | NodeId | Parent | PhysicalOp | LogicalOp | Argument | DefinedValues | EstimateRows | EstimateIO | EstimateCPU | AvgRowSize | TotalSubtreeCost | OutputList | Warnings | Type | Parallel | EstimateExecutions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 1 | select cast(@v1 as varchar(10)) union all select cast(@v2 as varchar(10)) |
2 | 1 | 0 | null | null | null | null | 2 | null | null | null | 2.157E-06 | null | null | SELECT | False | null |
| 2 | 1 | |--Constant Scan(VALUES:((CONVERT(varchar(10),[@v1],0)),(CONVERT(varchar(10),[@v2],0)))) | 2 | 2 | 1 | Constant Scan | Constant Scan | VALUES:((CONVERT(varchar(10),[@v1],0)),(CONVERT(varchar(10),[@v2],0))) | null | 2 | 0 | 2.157E-06 | 16 | 2.157E-06 | [Union1002] | null | PLAN_ROW | False | 1 |