Guidelines for using range-clustered tables

This topic lists some guidelines to follow when working with range-clustered tables (RCT).

• Because the process of creating a range-clustered table pre-allocates the required disk space, that space must be available.
• When defining the range of key values, the minimum value is optional; if it is not specified, the default is 1. A negative minimum value must be specified explicitly. For example:

  ORGANIZE BY KEY SEQUENCE (f1 STARTING FROM -100 ENDING AT -10)

• You cannot create a regular index on the same key values that are used to define the range-clustered table.
• ALTER TABLE statement options that affect the physical structure of the table are not allowed.