Hi Holger,

me again :-)

I didn't saw you're message in fbsupport before i replied.

> CREATE INDEX SSTRUK00_IDX1 ON SSTRUK00 (IDVISIB);
> CREATE INDEX SSTRUK00_IDX2 ON SSTRUK00 (IDTABELLE);
> CREATE INDEX SSTRUK00_IDX3 ON SSTRUK00 (IDVISIB, IDTABELLE);
> CREATE INDEX SSTRUK1 ON SSTRUK00 (BEZ);

I meant create a index that looks like :

CREATE INDEX SSTRUK00_IDX4 ON SSTRUK00 (BEZ, IDVISIB, IDTABELLE);

or maybe better

CREATE INDEX SSTRUK00_IDX4 ON SSTRUK00 (BEZ, IDTABELLE, IDVISIB);

but still when you don't need them, removing those indices is better.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81