Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
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
Content starts here

 » 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.

Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.