Range-clustered tables

A range-clustered table (RCT) has a table layout scheme in which each record in the table has a predetermined record ID (RID). The RID is an internal identifier that is used to locate a record in the table.

For each table that holds your data, consider which of the possible table types is best suited to your needs. For example, if you have data records that are loosely clustered (not monotonically increasing), consider using a regular table and indexes. If you have data records that have duplicate values in the key, do not use a range-clustered table. If you do not want to preallocate a fixed amount of storage on disk for range-clustered tables, do not use this type of table.