Home / CSE MCQs / SQL Server MCQs :: Discussion

Discussion :: SQL Server MCQs

  1. The space use of XML indexes can be found in the table-valued function named?
  2. 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

    View Answer

    Workspace

    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