Hi,

> below you find two select statements used in a 200MB Database
> first takes 11 minutes, second takes 4 seconds.

> all i have done is to enter a where clause on the field
> SSTRUKX.IDVISIB (which is indexed) and the value in the
> where clause is the default value (-1). When i take a
> value which is not used, it comes in less than a second.

I guess field SSTRUKX.IDVISIB has many values which are the same.
Remove the index SSTRUK00_IDX3 or create a new compound index on the fields
(fields from SSTRUK2, IDVISIB).

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