--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > --- In firebird-support@yahoogroups.com, "Alan McDonald"

<alan@m...>

> > wrote:
> > > > Here is the DDL from the FB 1.03.
> > > >
> > > > CREATE TABLE LEDGER (
> > > > ID DOUBLE PRECISION NOT NULL,
> > > > ENTERED_DATE TIMESTAMP,
> > > > EFFECTIVE_DATE TIMESTAMP,
> > > > CATEGORY_ID DOUBLE PRECISION,
> > > > DESCRIPTION VARCHAR(50),
> > > > COMPANY_ID DOUBLE PRECISION,
> > > > LEDGER_TYPE DOUBLE PRECISION,
> > > > CLEARED CHAR(1),
> > > > MEMO VARCHAR(1000),
> > > > CHK_AMT NUMERIC(9,2),
> > > > DEPOSIT_AMT NUMERIC(9,2),
> > > > USERID SMALLINT);
> > > >
> > > > ALTER TABLE LEDGER ADD CONSTRAINT ILEDGER_ID PRIMARY KEY (ID);
> > > >
> > > > CREATE INDEX ILEDGER_CATEGORY_ID ON LEDGER (CATEGORY_ID);
> > >
>
> Can you put some indexes on these date fields please and see what

shange

> there is?
> Even if they are only all ascending indexes it will be faster -

maybe

> descending as well.
> Alan

I have tried indexing every field, as well as adding fields to the
index you see above, with no improvement.