sys-plan-guides-transact-sql.md

title	sys.plan_guides (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.planguides_TSQL plan_guides sys.planguides plan_guides_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.plan_guides catalog view
ms.assetid	3dde0397-ef6f-4b3f-8250-3f25584eb62b
author	stevestein
ms.author	sstein
manager	craigg
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.plan_guides (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

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

[!INCLUDEssCatViewPerm] 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)