Package element: Merge Join Output
Properties
| Name | Value |
| Dangling | False |
| DeleteOutputOnPathDetached | False |
| Description | |
| ErrorOrTruncationOperation | |
| ErrorRowDisposition | RD_NotUsed |
| ExclusionGroup | 0 |
| HasSideEffects | False |
| ID | 244 |
| IdentificationString | MRG - Append last stats on interesting queries.Outputs[Merge Join Output] |
| IsAttached | True |
| IsErrorOut | False |
| IsSorted | True |
| Name | Merge Join Output |
| ObjectType | OT_OUTPUT |
| SynchronousInputID | 0 |
| TruncationRowDisposition | RD_NotUsed |
Elements
| Name | Description | Type |
| statement_start_offset | OutputColumnCollection | |
| statement_end_offset | OutputColumnCollection | |
| plan_generation_num | OutputColumnCollection | |
| creation_time | OutputColumnCollection | |
| last_execution_time | OutputColumnCollection | |
| execution_count | OutputColumnCollection | |
| total_worker_time | OutputColumnCollection | |
| total_physical_reads | OutputColumnCollection | |
| total_logical_writes | OutputColumnCollection | |
| total_logical_reads | OutputColumnCollection | |
| total_clr_time | OutputColumnCollection | |
| total_elapsed_time | OutputColumnCollection | |
| max_worker_time | OutputColumnCollection | |
| min_worker_time | OutputColumnCollection | |
| min_physical_reads | OutputColumnCollection | |
| max_physical_reads | OutputColumnCollection | |
| min_logical_writes | OutputColumnCollection | |
| max_logical_writes | OutputColumnCollection | |
| min_logical_reads | OutputColumnCollection | |
| max_logical_reads | OutputColumnCollection | |
| min_clr_time | OutputColumnCollection | |
| max_clr_time | OutputColumnCollection | |
| min_elapsed_time | OutputColumnCollection | |
| max_elapsed_time | OutputColumnCollection | |
| collection_time | OutputColumnCollection | |
| sql_handle | OutputColumnCollection | |
| plan_handle | OutputColumnCollection | |
| snapshot_id | OutputColumnCollection | |
| old_total_worker_time | OutputColumnCollection | |
| old_total_physical_reads | OutputColumnCollection | |
| old_total_logical_writes | OutputColumnCollection | |
| old_total_logical_reads | OutputColumnCollection | |
| old_total_clr_time | OutputColumnCollection | |
| old_total_elapsed_time | OutputColumnCollection | |
| old_execution_count | OutputColumnCollection |
See also