Federico,

>I am not sure, but do you have indices on all fields?

All fields are declared as foreign- or primary keys, so the primary keys are indexed, the foreign keys are not.

> (Maybe when you changed the code style you didn´t allow the SQL engine to optimize...) Did you try using the new JOIN style?

What is the new JOIN style?

> Which data server are you using?

SQL Server 6.5

Thanks in advance for any reply.
Marco Beuk.