Stage 3: Third single-level partitioning of the orders table - Teradata Vantage

Suppose you submit the following ALTER TABLE request on orders:

ALTER TABLE orders
  MODIFY PRIMARY INDEX
  ADD RANGE BETWEEN 5
            AND     9
            EACH    1;

This alters the partitioning expression to:

RANGE_N(o_custkey BETWEEN 5
                  AND     9
                  EACH    1, 10 AND 100
                  EACH   10);

That is, the table definition after you have performed the ALTER TABLE request is as follows:

CREATE TABLE orders (
  o_orderkey INTEGER NOT NULL,
  o_custkey INTEGER)
PRIMARY INDEX (o_orderkey)
PARTITION BY
RANGE_N(o_custkey BETWEEN 5 
                  AND     9
                  EACH    1, 10 AND 100
                  EACH   10); /* p1 */

The following table indicates the new partition numbers for the defined ranges for o_custkey.

This table describes the PARTITION#L n values for a table having a 2-byte ROWID. With an 8-byte ROWID, the table has up to 62 partitions.