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.