sys.plan_guides (Transact-SQL)
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
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.