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

title	sys.dm_exec_valid_use_hints (Transact-SQL)
description	sys.dm_exec_valid_use_hints (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	11/17/2016
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
ms.custom	ignite-2025
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
helpviewer_keywords	sys.dm_exec_valid_use_hints management view
dev_langs	TSQL

sys.dm_exec_valid_use_hints (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

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)