Skip to content

index-related-dynamic-management-views-and-functions-transact-sql.md

Latest commit

 

History

History
46 lines (36 loc) · 2.53 KB

index-related-dynamic-management-views-and-functions-transact-sql.md

File metadata and controls

46 lines (36 loc) · 2.53 KB
title Index Related Dynamic Management Views and Functions (Transact-SQL)
description Index Related Dynamic Management Views and Functions (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.date 03/20/2017
ms.service sql
ms.subservice system-objects
ms.topic reference
helpviewer_keywords
index dynamic management objects [SQL Server]
dynamic management objects [SQL Server], index
dev_langs
TSQL

Index Related Dynamic Management Views and Functions (Transact-SQL)

[!INCLUDE SQL Server]

This section contains the following dynamic management objects.

:::row::: :::column::: sys.dm_db_column_store_row_group_physical_stats (Transact-SQL)

    [sys.dm_db_index_operational_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-index-operational-stats-transact-sql.md)

    [sys.dm_db_index_usage_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql.md)

    [sys.dm_db_missing_index_details (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-missing-index-details-transact-sql.md)
:::column-end:::
:::column:::
    [sys.dm_db_missing_index_groups (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-missing-index-groups-transact-sql.md)

    [sys.dm_db_index_physical_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql.md)

    [sys.dm_db_missing_index_columns (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-missing-index-columns-transact-sql.md)

    [sys.dm_db_missing_index_group_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-missing-index-group-stats-transact-sql.md)
:::column-end:::

:::row-end:::

See Also

Dynamic Management Views and Functions (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
System Views (Transact-SQL)