Concepts > Attributes (MetaAttributes) > ORDER \ DB2 10.5
ORDER \ DB2 10.5
ASC
Specifies that index entries are to be kept in ascending order of the column
values; this is the default setting. ASC cannot be specified for indexes that are
defined with EXTEND USING (SQLSTATE 42601).
DESC
Specifies that index entries are to be kept in descending order of the column
values. DESC cannot be specified for indexes that are defined with EXTEND
USING, or if the index is an index over XML data (SQLSTATE 42601).
RANDOM
Specifies that index entries are to be kept in random order of the column
values.
Translations
Type
String (1) Enumeration
 
List of MetaClasses
Value
(A), (D), (R).