Skip to content

Latest commit

 

History

History
39 lines (31 loc) · 1.53 KB

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

File metadata and controls

39 lines (31 loc) · 1.53 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.dm_exec_valid_use_hints (Transact-SQL)
sys.dm_exec_valid_use_hints (Transact-SQL)
rwestMSFT
randolphwest
11/17/2016
sql
system-objects
conceptual
sys.dm_exec_valid_use_hints
sys.dm_exec_valid_use_hints_TSQL
dm_exec_valid_use_hints
dm_exec_valid_use_hints_TSQL
sys.dm_exec_valid_use_hints management view
TSQL

sys.dm_exec_valid_use_hints (Transact-SQL)

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

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)