Rows of data can be grouped into ranges and assigned to tablespaces. This is done when the table is created by using the CREATE TABLE statement. This determines how data is physically stored on the disk. Data ranges are created using range-clustered tables, or by taking advantage of range partitioning tables.
Range clustering and range partitioning tables
Range clustered tables
A range clustered table (RCT) is a table whose data is organized by a unique, not null integer record key, with a predetermined set of ranges based on each column of the key. These tables are useful when data is tightly clustered across one or more columns in a table. Each possible key value in the defined range has a predetermined location in the physical...