Secondary Considerations for Selecting a Primary Index
When you select primary indexes for your tables, there are several factors to keep in mind that are not orthogonal to the three principle selection criteria described in “Principal Criteria for Selecting a Primary Index” on page 407.
These considerations include the following factors.
Primary indexes in Teradata Database are not stored in an index subtable, but are just a column set that is designated as the primary index at the time the table is created (or, rarely, when its primary index is altered), space management issues that are unique to primary indexes are minimal.
The only factors are the following two:
If a table does not have a partitioned primary index, then the partition number for each row is assumed to be 0, and nothing is stored in the row header to represent a partition number other than flag bits that occur every row (see “Storage and Other Overhead Considerations for Partitioning” on page 332).
Each of these considerations is described in further detail in additional topics in this chapter.