Adaptive Server includes several tools that provide information on the current sizes of tables or indexes or that can predict future sizes:
The utility program optdiag displays the sizes and many other statistics for tables and indexes. For information on using optdiag, see Chapter 6, “Statistics Tables and Displaying Statistics with optdiag.” in the book Performance and Tuning: Monitoring and Analyzing for Performance.
The system procedure sp_spaceused reports on the current size of an existing table and any indexes.
The system procedure sp_estspace can predict the size of a table and its indexes, given a number of rows as a parameter.
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.
