Subject Re: [firebird-support] Re: rebuild primary key index?
Author Ann W. Harrison
gabrielsenkim wrote:

> but does it mean that i can't change the 'sort order' of the primary key index?


> if i issue a query sorted as asc instead of desc it's instantaneous
> while it takes a long time to see the results when sorting desc.

It takes a long time to see the first row, but less time to see all
the rows. But if you care about the time to return the first row,
then define a second descending index.

Good luck,