15.00 - Assigning Excess Combined Partitions to Partitioning Levels - Teradata Database

Teradata Database Design

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

Assigning Excess Combined Partitions to Partitioning Levels

Teradata Database assigns leftover partitions to different partitioning levels depending the following set of rules.

 

 

IF the partitioning is …

THEN Teradata Database adds as many leftover combined partitions as possible to the …

single‑level

first and only row or column partitioning level and the ADD value is overridden if one is specified.

multilevel and …

 

 

all the row partitioning levels have an ADD clause, but there is a column partitioning level without an ADD clause

column-partitioning level, which does not need to be at the first partitioning level.

 

a column partitioning level and at least one of the row partitioning levels does not specify an ADD clause, including the case where none of the row partitioning levels specify an ADD clause

first row-partitioning level without an ADD clause after using a default of ADD 10 for the column-partitioning level.

This is repeated for each of the other row partitioning levels without an ADD clause in partitioning level order.

 

a column partitioning level has an ADD clause and at least 1 of the row partitioning levels does not specify an ADD clause

first row partitioning level without an ADD clause.

This is repeated for each of the other row partitioning levels without an ADD clause in partitioning level order

 

 

there is no column partitioning level and at least 1 of the row partitioning levels does not have an ADD clause, including the case where none of the row partitioning levels specify an ADD clause

 

all the partitioning levels specify an ADD clause or after applying leftover combined partitions

first row or column partitioning level and the ADD clause for the first partitioning level, if specified, is overridden.

If there at least 1 level that specifies an explicit ADD clause, there is at least 1 level that consists only of a RANGE_N function with BIGINT data type, there is column partitioning, or the partitioning is 8-byte, this is repeated for each of the other levels from the second level to the last level.