sys.plan_guides (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Contains a row for each plan guide in the database.
Column name | Data type | Description |
---|---|---|
plan_guide_id | int | Unique identifier of the plan guide in the database. |
name | sysname | Name of the plan guide. |
create_date | datetime | Date and time the plan guide was created. |
modify_date | Datetime | Date the plan guide was last modified. |
is_disabled | bit | 1 = Plan guide is disabled. 0 = Plan guide is enabled. |
query_text | nvarchar(max) | Text of the query on which the plan guide is created. |
scope_type | tinyint | Identifies the scope of the plan guide. 1 = OBJECT 2 = SQL 3 = TEMPLATE |
scope_type_desc | nvarchar(60) | Description of scope of the plan guide. OBJECT SQL TEMPLATE |
scope_object_id | Int | object_id of the object defining the scope of the plan guide, if the scope is OBJECT. NULL if the plan guide is not scoped to OBJECT. |
scope_batch | nvarchar(max) | Batch text, if scope_type is SQL. NULL if batch type is not SQL. If NULL and scope_type is SQL, the value of query_text applies. |
parameters | nvarchar(max) | The string defining the list of parameters associated with the plan guide. NULL = No parameter list is associated with the plan guide. |
hints | nvarchar(max) | The OPTION clause hints associated with the plan guide. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)