Estimating Table and Index Sizes

As was pointed out in the preceding chapter, space management is a very critical issue and responsibility for DBAs. Although there are the very routine aspects of monitoring tablespace and disk space usage over time and making projections for the future based on that history, DBAs are also often asked to estimate how big an object will be merely based on the estimated row count. For example, how large will this table be if it had a million instead of ten thousand rows? TOAD provides estimate screens of just this nature for both tables and indexes.

The TOAD Table Size Estimator is accessible from the main menu at Tools|Estimate Table Size and offers three methods for estimating table sizes. First and by default, ...

Get TOAD® Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.