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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
