<< Click to Display Table of Contents >>

Estimate the space required by an index

Top Previous Next

This dialog lets you estimate the disk space requirements of an index. You can use the results to define storage parameters or to estimate storage space.

The first row of combo boxes shows the owner, table and index name of the index currently selected by the calling dialog. You can change them to any other index without closing the dialog.

The database block size is a server constant. It cannot be changed once the database has been created.

The average size of an index entry can be estimated by two different methods:

The size is determined by the average row size of existing data. Assuming the table contains typical data, this method gives the best approximation. However, it may take some time, especially for large tables.

The size is determined by the maximum size of the table structure. The method returns the maximum space required; however, the real data will not completely fill the structure.

You can increase the number of entries and press the Calculate button. The result will be the estimated total size of the index data.