You can significantly reduce the time R:BASE takes to process an ORDER BY clause when the column or columns listed in the ORDER BY clause are included in an index with the same column sort order as that specified in the ORDER BY clause.
An example would be if you are processing data by the invoice date and listing the results descending order, so the most current invoices appear first, you would have an index on the table's invoice date column that was created to process the data in the descending order as well.
