Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| group_handle | int | 4 | null |
|
|
|||
| query_hash | binary | 8 | null |
|
|
|||
| query_plan_hash | binary | 8 | null |
|
|
|||
| last_sql_handle | varbinary | 64 | null |
|
|
|||
| last_statement_start_offset | int | 4 | null |
|
|
|||
| last_statement_end_offset | int | 4 | null |
|
|
|||
| last_statement_sql_handle | varbinary | 64 | √ | null |
|
|
||
| user_seeks | bigint | 8 | null |
|
|
|||
| user_scans | bigint | 8 | null |
|
|
|||
| last_user_seek | datetime | 16,3 | √ | null |
|
|
||
| last_user_scan | datetime | 16,3 | √ | null |
|
|
||
| avg_total_user_cost | float | 8 | √ | null |
|
|
||
| avg_user_impact | float | 8 | null |
|
|
|||
| system_seeks | bigint | 8 | null |
|
|
|||
| system_scans | bigint | 8 | null |
|
|
|||
| last_system_seek | datetime | 16,3 | √ | null |
|
|
||
| last_system_scan | datetime | 16,3 | √ | null |
|
|
||
| avg_total_system_cost | float | 8 | √ | null |
|
|
||
| avg_system_impact | float | 8 | null |
|
|
Relationships
Close relationships within degrees of separation
