MySQL Query Tuning

Hi All,

I am a new user for MySQL, I need to improve one slow performance query which is using joins commonly. I need some help to improve it, Does anyone knows about Query tuning. Thank you

Hi Tom, thank you for the reply. The links are quit useful for me. But I am looking for an alternate of Left join and where if classes, Which is in that slow performance query.


Can you provide the query which you want to tune and “SHOW CREATE TABLE” for all those tables which are involved in that query? Explain plan will be also helpful. Thanks.