sys-dm-exec-valid-use-hints-transact-sql.md

title	sys.dm_exec_valid_use_hints (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	11/17/2016
ms.prod	sql
ms.reviewer
ms.suite	sql
ms.technology	system-objects
ms.tgt_pltfrm
ms.topic	conceptual
f1_keywords	sys.dm_exec_valid_use_hints sys.dm_exec_valid_use_hints_TSQL dm_exec_valid_use_hints dm_exec_valid_use_hints_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_exec_valid_use_hints management view
ms.assetid	65d50589-39c2-4046-92b6-0c4587d8c593
caps.latest.revision	5
author	pmasl
ms.author	pelopes
manager	craigg

sys.dm_exec_valid_use_hints (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]

Returns USE HINT supported hint names. It lists one hint name per row.

Use this DMV to see the list of all supported hints under the USE HINT notation.

Column Name	Data Type	Description
name	sysname	The name of the hint.

See Query Hints for descriptions of each hint.

Introduced in [!INCLUDEssSQL15_md] SP1.

See Also

Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)