Hi,

> I want to do something like:
> Select Count(*) From Employee E Inner Join Employer R On
> (E.EmployerId=R.Id) Where R.Id In (10,20,30)
>
> This is very slow; When I do Where R.Id=10 it is very fast. What is
> wrong with my query?

Show us the PLAN returned by the engine and tell us what Firebird version you
use.

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