MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizing query with joins
Posted by: Rob Blick
Date: June 07, 2006 10:17AM

The first thing that jumps out at me are your LIKE '%blah%' clauses. Those kill you, because no index can help (LIKE 'blah%' will benefit, but not LIKE '%blah%'). MySQL is doing table scans on your civicrm_contact and civicrm_email tables. If those are MyISAM tables, you may be able to garner some help from fulltext indexes (though you'll need to rewrite the query to use MATCH... AGAINST).

Options: ReplyQuote

Written By
June 03, 2006 12:18PM
Re: Optimizing query with joins
June 07, 2006 10:17AM
February 12, 2007 12:07PM

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.