Sail E0 Webinar
Question
The space use of XML indexes can be found in the table-valued function named?
Options:
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


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.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers