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