Specify the organization of the table. Values are R, U, S, D, and H. The default is R.

R (Random)

New rows are added to the end of the table if a table has Random organization. When a row is deleted, the last row moves to the vacated position. This organization keeps overall data movement to a minimum. Searching must be done with the Serial method.

U (User-ordered)

The order of the rows is controlled by the user. Searching must be done with the Serial method.

S (Sequential)

Rows are ordered by key in ascending sequence. Various search techniques can be used. Insertion and deletion tend to be slower than Random and user-ordered organization because rows must be moved to maintain the sequence.

D (Descending)

This is the same as Sequential order, except rows are ordered in descending sequence.

H (Hash)

Rows are organized by arithmetic operations on the key fields.