Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| plan_id | bigint | 8 | null |
|
|
|||
| query_id | bigint | 8 | null |
|
|
|||
| plan_group_id | bigint | 8 | √ | null |
|
|
||
| engine_version | nvarchar | 64 | √ | null |
|
|
||
| compatibility_level | smallint | 2 | null |
|
|
|||
| query_plan_hash | binary | 8 | null |
|
|
|||
| query_plan | nvarchar | 2147483647 | √ | null |
|
|
||
| is_online_index_plan | bit | 1 | null |
|
|
|||
| is_trivial_plan | bit | 1 | null |
|
|
|||
| is_parallel_plan | bit | 1 | null |
|
|
|||
| is_forced_plan | bit | 1 | null |
|
|
|||
| is_natively_compiled | bit | 1 | null |
|
|
|||
| force_failure_count | bigint | 8 | null |
|
|
|||
| last_force_failure_reason | int | 4 | null |
|
|
|||
| last_force_failure_reason_desc | nvarchar | 256 | √ | null |
|
|
||
| count_compiles | bigint | 8 | √ | null |
|
|
||
| initial_compile_start_time | datetimeoffset | 20,7 | null |
|
|
|||
| last_compile_start_time | datetimeoffset | 20,7 | √ | null |
|
|
||
| last_execution_time | datetimeoffset | 20,7 | √ | null |
|
|
||
| avg_compile_duration | float | 8 | √ | null |
|
|
||
| last_compile_duration | bigint | 8 | √ | null |
|
|
||
| plan_forcing_type | int | 4 | null |
|
|
|||
| plan_forcing_type_desc | nvarchar | 120 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
