Subject Re: [firebird-support] FIREBIRD Mixed SORT in key/index
Author Ann W. Harrison
At 05:23 AM 7/20/2004, Johan van Zyl wrote:
>Can one now have a multiple key/index with mixed sort?
>InvoiceDate Descending
>CustomerName Ascending
>If not now then when can we expect it?

You can mix ascending and descending in an ORDER BY clause, but
not in an index definition. To the best of my knowledge, there
are no plans to change that situation. Many programmers suffer
from an irrational fear of sorting and insist on building indexes
to avoid what is a simple, reasonably quick operation in most
cases. Indexes are essential for locating records. The fact that
they impose an order is a secondary effect.