Re: Unused index, slow query
Hi,
from what I can see s2.pseudo is used to find j.login, not the other way round.
Am I right? s2.pseudo is not used to find the row in systemes s2 but in jours j?
In that case the explain possible key 'pseudo' is missleading.
Try index nom in systemes, but I'm uncertain if mysql uses index when using '<>'
But I should give it a try, if mysql use it and the cardinality is good.
Subject
Views
Written By
Posted
4410
May 20, 2008 06:48AM
Re: Unused index, slow query
1727
May 21, 2008 09:08PM
1532
May 28, 2008 12:08AM
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.