• It is also helpful to know how much space is used by the index. Here is how I did that:

    CONVERT(DECIMAL(8,2), i.dpages / 128.0) AS MBUsed

    EDIT: I should note that I used sys.sysindexes rather than sys.indexes. However, sys.sysindexes may not be supported in future versions of SQL Server.