Re: Slow query performance
Hi,
Is there a combined index on image (msj_nro,plz_id, via_id)? That is the only thing I see that will be useful for the query. The problem is that you are retrieving every row from menssage no matter what. That will cause MySQL to always do a full table scan. Without a WHERE or LIMIT or anything else similar, there isn't going to be much you can do, since it is going to return so much data.
Is there any reason why you are returning so much data? If you had a million rows in menssage, then the query would return at least one million rows, if not more.
Subject
Views
Written By
Posted
3685
October 15, 2004 06:06AM
Re: Slow query performance
2559
October 15, 2004 11:28AM
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.