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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement