A cluster key can be a single column (for example, stock_num) or a composite of up to 16 columns (for example, stock_num, manu_code). You cannot specify a TEXT or BYTE data column as a cluster key. The maximum length of a cluster key is 390 bytes. An error message is returned if you submit a cluster key that is longer than 390 bytes.
You can gain better performance if you organize the columns in a composite cluster key so that the column with the fewest number of duplicate values is placed first.
You can create more than one optical cluster for the same list of cluster-key columns. This option differs from the restrictions placed on indexes, each of which you must create from a unique set of index-key columns.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]