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 |
|
|