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

You may as well try indexes on ledger_type and compay_id too.
Mind you - I would not have them as double precision. Why don't you change
them too - to integer.
What does the trigger look like on your PK?
Alan