Re: Reqûete lente
Bonjour,
Il est normal que cela soit de plus en plus lent puisqu'il nous reste deux
tables sur lesquelles il y a un scan complet (type = ALL).
Compte tenu des conditions se trouvant dans le WHERE, on ne pourra pas éviter
le scan complet de la table Pl.
Par contre, il est possible qu'un index sur la colonne id de la table comptes
puisse améliorer les performances.
Thomas CORBIERE
Subject
Views
Written By
Posted
4810
February 16, 2007 03:59AM
3215
February 16, 2007 06:23AM
3457
February 16, 2007 08:35AM
3180
February 16, 2007 12:10PM
3261
February 17, 2007 07:50AM
Re: Reqûete lente
3097
February 23, 2007 01:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.