Sorting records
Go Up to Working with Tables
An index determines the display order of records in a table. In general, records appear in ascending order based on a primary index. This default behavior does not require application intervention. If you want a different sort order, however, you must specify either
- An alternate index.
- A list of columns on which to sort.
Specifying a different sort order requires the following steps:
- Determining available indexes.
- Specifying the alternate index or column list to use.