Hi Michael,

> > 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?

Indices aren't (usually) meant to speed up the ORDER BY process. They
are used to speed up lookups.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."