> You were probably thinking of the ORDER BY clause of a query which does
> allow each field declared to be either ascending or descending. <g>
>
> Woody (TMW)

well no (and yes)
i thought: if i want to speed up some sortorder that does use asc and desc
at the same time i cannot create a single index to speed up this sortorder.
i actually have used single column indexes in these circumstances.
as some other people already stated this is the way to do it.

i still feel that this is some kind of limitation but it's the way firebird
works. would it make sense to post this as feature request or do you
consider this nonsense?

thanks for reading
michael