Re: Mysql query performance
Posted by: Bob Field
Date: September 03, 2006 04:42PM

Certainly adding joins to a query is going to increase overhead. The impact can be a little or a lot, depending on a number of factures, particularly indexes available to help the join process. I would start by indexing all the fields used in the join conditions, then do an EXPLAIN to see if there is any additional tunining that can be done.

Options: ReplyQuote


Subject
Written By
Posted
July 19, 2006 07:35AM
July 19, 2006 08:23AM
July 20, 2006 08:49AM
August 31, 2006 01:04PM
September 03, 2006 04:29PM
Re: Mysql query performance
September 03, 2006 04:42PM


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.