15.00 - Example Measurement 2 - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Example Measurement 2

This example examines the size of a simple join index created for the same tables used in “Example Measurement 1” on page 601. There is a savings of 8 bytes because there is no COUNT column and no SUM(INTEGER) column.

The computed row size is as follows:

The permanent space specification is as follows.

 

Current Permanent Space (Bytes)

Peak Permanent Space (Bytes)

Maximum Permanent Space (Bytes)

1,561,216,000

1,561,216,000

0

Using these figures, you can compute a measured row size.

As with “Example Measurement 1” on page 601, the measured and computed disk spaces are identical, and you can conclude that the disk space formula is accurate for a simple join index.