Stage 4: Fourth single-level partitioning of the orders table - Teradata VantageCloud Lake

Suppose you submit the following ALTER TABLE request on orders:

ALTER TABLE orders
  MODIFY PRIMARY INDEX
  ADD RANGE BETWEEN 0
            AND     4
            EACH    2;

RANGE_N(o_custkey BETWEEN 0
                  AND     4
                  EACH    2,  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 0
                               AND     4
                               EACH    2, 5 AND 9
                               EACH    1, 10 AND 100
                               EACH   10);

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