Discussion :: SQL Server MCQs
- The space use of XML indexes can be found in the table-valued function named?
A.
sys.dm_db_index_physical_stats
|
B.
sys.dm_db_index_phy_stats
|
C.
sys.dm_db_index_plan_stats
|
D.
sys.dm_db_index_table_stats
|
Answer : Option A
Explanation :
sys.dm_db_index_physical_stats provides information, such as the number of disk pages occupied, average row size in bytes, and number of records, for all index types.
Be The First To Comment