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 |
|
|
|
[!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.
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)