Subject Re: [firebird-support] Re: rebuild primary key index?
Author Fidel Viegas
On Tue, Mar 24, 2009 at 4:57 PM, gabrielsenkim
<kim.gabrielsen@...> 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.
> maybe i should create another index including the primary key and order it
> desc. would that help?

Yes, if you need to create a descending index on your primary key.

> is there a way to see the executing plan? i'm unable to find it in the
> documentation (or i might have looked in the wrong place)

If you are using the isql utility, then you can do it by typing SET PLAN ON

Hope that helps.