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:A
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
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.