Subject RE: [firebird-support] FIREBIRD Mixed SORT in key/index
Author Johan van Zyl
I am new to SQL so that is why I am still asking silly questions.
I have been using Clarion with its proprietary TOPSPEED (.tps) file driver
(flat file) up to now.
So it is a bit of a paradigm shift for me!
-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: 20 July 2004 04:11
Subject: Re: [firebird-support] FIREBIRD Mixed SORT in key/index

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.



Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.722 / Virus Database: 478 - Release Date: 2004/07/18

[Non-text portions of this message have been removed]