Hi,

> FB (1.5.2) seems to have a problem with this query join structure.
> If I run it in MS SQL, it returns about 750 records in just a few
> seconds which is reasonable and expected for the data. If I run it
> against the same data loaded into Firebird, it goes nuts. Tested it
> in
> IBAccess and it kept counting to well over 200K before I canceled it.
>
> select S1.userid, S1.groupid, S.username
> from S
> inner join S S1 on
> S1.userid=S.userid
> where S.groupid='004'

is S.groupid also indexed?

Beside that, show us the PLAN reported by the engine and we can tell more.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

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