TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

sys.plan_guides

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.

Show:
© 2016 Microsoft