HPlogo Up and Running with ALLBASE/SQL: HP 3000 and HP 9000 Computer Systems > Chapter 2 Looking at Data

Estimating Table and Index Size

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.

Feedback to webmaster