Subject Re: [ib-support] RE: indexes are one way streets
Author Martijn Tonies
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
> 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
> 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

Upscene Productions

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