Previous Topic: Relative Size of Indexes to TablesNext Topic: Split Files Across Multiple Physical Drives


Estimate CSE Size

A medium encyclopedia contains about 250,000 objects and a large encyclopedia contains about 500,000 objects.

The actual amount of space required for the CSE depends on the operating system and the DBMS. However, you can base an estimate on the size of the DOBJ table.

To calculate a rough estimate of the size to allow for the CSE, use a formula within the following range:

Low: CSE size (in Kbytes) = 1. 75 * DOBJ

High: CSE size (in Kbytes) = 1.9 * DOBJ

The previous formula is based on the following assumptions:

Table Name

Size Relative to DOBJ

Description

DASC

.5

DASC is about half the size of DOBJ

DNAME

.2

Approximately 25 percent of DOBJ rows have a corresponding row in this table. The DNAME row is shorter than the DOBJ row.

DSUBEX

0 - .1

Varies depending on the extent subsetting is used. If there is no subsetting, do not include this factor in estimate.

All others

> .1

The total size of all remaining tables is less than 10 percent the size of DOBJ.