Tools for determining the sizes of tables and indexes

Adaptive Server includes several tools that provide information on 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. The sp_spaceused and optdiag commands report actual space usage. The other methods presented in this chapter provide size estimates. For partitioned tables, the system procedure sp_helpartition reports on the number of pages stored on each partition of the table. See “Getting information about partitions” for information.