MySQL Forums
Forum List  »  Performance

Re: Simple left join query with abysmal performance.
Posted by: Simon Courchesne
Date: June 16, 2005 10:25AM

Indeed! Thx guys, I figured that I had some missing Index. I added an index on LNK_ACTMOV.MOV_ID and now the perfrmance is back to what it should be!

You learn something new everyday, and today was rather hard!

Simon.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Simple left join query with abysmal performance.
2531
June 16, 2005 10:25AM


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.