MySQL Forums
Forum List  »  French

Re: Reqûete lente
Posted by: Thomas CORBIERE
Date: February 23, 2007 01:36AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
4734
February 16, 2007 03:59AM
3185
February 16, 2007 06:23AM
3420
February 16, 2007 08:35AM
3143
February 16, 2007 12:10PM
3218
February 17, 2007 07:50AM
Re: Reqûete lente
3059
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.