none
How to query the noncluster index used space. RRS feed

  • 問題

  • hello.How to query the noncluster index used space. i know the storece procedure "sp_spaceused" can query the cluster index space. but now i want to know the noneclusterindex space?  thanks for reply.

    2012年5月13日 上午 05:16

所有回覆

  • Try with 'dbcc showcontig (table_name) with all_indexes' or 'dbcc showcontig (index_name)', it tells you number of pages used by an index and free space on each page.
    2012年5月13日 下午 10:05