15.00 - Table Sizing Summary - Teradata Database

Teradata Database Design

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

Table Sizing Summary

The following list reviews the principal points to remember about estimating the table space requirements for your new database.

  • Accurate estimates require accurate base data. The minimum base data required for these estimates are the following.
  • Cardinalities (or anticipated cardinalities) of your tables
  • Row size estimates
  • Remember that all row lengths must be an even number of bytes (see “Byte Alignment” on page 770), so be sure to take this into account.

  • Estimate sizes for all the following database objects.
  • Base tables
  • Base table fallback tables (when defined)
  • LOB and XML subtables
  • Secondary indexes
  • Secondary index fallback tables (when defined)
  • Hash indexes
  • Hash index fallback tables (when defined)
  • Join indexes (including any secondary indexes defined on them)
  • Join index fallback tables (when defined)
  • Spool space
  • Stored procedures