SALG : 1-800-867-1389
Expand Minimize
EN
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

sys.dm_db_missing_index_groups

Updated: April 2, 2011

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.

Syntes du, dette var nyttigt?
(1500 tegn tilbage)
Tak for din feedback

Fællesskabsindhold

Tilføj
Vis:
© 2014 Microsoft