Eksportér (0) Udskriv
Udvid alt
EN
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

sys.dm_db_missing_index_groups

Updated: November 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see sys.dm_db_missing_index_groups.

Returns information about what missing indexes are contained in a specific missing index group, excluding spatial indexes.

In Microsoft Azure SQL Database, dynamic management views cannot expose information that would impact database containment or expose information about other databases the user has access to. To avoid exposing this information, every row that contains data that doesn’t belong to the connected tenant is filtered out.

 

Column name Data type Description

index_group_handle

int

Identifies a missing index group.

index_handle

int

Identifies a missing index that belongs to the group specified by index_group_handle.

An index group contains only one index.

Information returned by sys.dm_db_missing_index_groups is updated when a query is optimized by the query optimizer, and is not persisted. Missing index information is kept only until SQL Server is restarted. Database administrators should periodically make backup copies of the missing index information if they want to keep it after server recycling.

Neither column of the output result set is a key, but together they form an index key.

Requires VIEW DATABASE STATE permission on server. Cannot be queried from the master database. For more information, see Dynamic Management Objects.

Vis:
© 2015 Microsoft