15.00 - Considerations for Measuring Disk Space - Teradata Database

Teradata Database Design

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

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.