gabrielsenkim wrote:

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

Right.

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

Ann