HP 3000 Manuals

Up and Running with ALLBASE/SQL

Estimating Table and Index Size 

In order to implement your table design, you need to estimate the amount
of disk space required for your tables and any indexes you plan to
create.  Then, when you create DBEFiles to contain the data, specify a
size that is big enough to hold the rows you want to store plus some room
for growth.

The tutorial in chapter 3 uses file sizes that are more than adequate for
the sample database you are creating.  Before creating a large database,
calculate your space requirements carefully.  Complete information about
size calculation for tables and indexes is given in the "Physical Design"
chapter of the ALLBASE/SQL Database Administration Guide. 

MPE/iX 5.0 Documentation