Hi Michael,

> I actually have a select that runs very fast, as long as I don't use
> IN....
>
> The SQL is like this

<snip>

Give some more information about these indexes:

INDEX (INTEG_173)
INDEX (INTEG_194)
INDEX (INTEG_190)

INDEX (INTEG_258)
INDEX (INTEG_260,INTEG_261,INTEG_261),
INDEX (INTEG_173)

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info