Sorting Options By Using existing indexes on the tables

To use an index on a select statement, use the keyword index followed by the
name of the index:

1 2 3 4 5 6 7

CustTable custTable; while select custTable index AccountIdx { print custTable.AccountNum, " ", custTable.currency; } pause;

The result of this search is in the order specified by the index. You can view
available indexes for a given table in the Application Object Tree (AOT).
Indexes should only be specified when the sequence of records is important and
that sequence matches the index exactly.

Best Regards,
Hossein Karimi