At 11:54 AM 12-08-02 +0200, you wrote:

>well, this is the problem: this does not work. one can specify ascending or
>descending only at the beginning like in:
>create descending index myindex on people (first_name, birthday)
>but not for every part of the index seperately.
>any ideas/comments?

Create separate indexes! (intelligently and with restraint, of course...)
The optimizer will do the rest of it for you when you run your
queries. Make sure you do proper load testing as well, since the optimizer
may use different plans under different load conditions.

Composite indexes are OK in very strict moderation, for very specific
purposes and bearing in mind that they have very limited size.

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________