Considerations for Measuring Disk Space - Teradata Database

Considerations for Measuring Disk Space

Keep the following rules of thumb in mind whenever you perform these calculations.

Implement your measurements over a very large number of rows to avoid distorting the figures with table overhead issues.

An INTEGER column uses 4 bytes.

A SUM(INTEGER) column uses 8 bytes because the system always casts it to FLOAT.

If you have not explicitly specified a COUNT column in your aggregate join index definition, add 4 bytes to the definition to account for the required COUNT column.