Determining the sizes of tables and indexes

Adaptive Server includes several tools that provide information about the current sizes of tables or indexes, or that can predict future sizes:

You can also compute table and index size using formulas provided in this chapter. sp_spaceused and optdiag report actual space usage. The other methods presented in this chapter provide size estimates.

For partitioned tables, sp_helpartition reports on the number of pages stored on each partition of the table. See Chapter 10, “Partitioning Tables and Indexes” in the Transact-SQL Users Guide.