MySQL Forums
Forum List  »  Newbie

Re: procedure and query optemization
Posted by: Peter Brawley
Date: February 19, 2014 02:39PM

Run EXPLAIN EXTENDED on the query. Each (sub)query gets one line in the analysis. The lines that show no index being used are likely the query clauses that are slowing down the query. If it's too puzzling, post the EXPLAIN EXTENDED query here in human-readable format using BBCode code tags, along with SHOW CREATE TABLE results for all tables in the problematic query.

Options: ReplyQuote


Subject
Written By
Posted
Re: procedure and query optemization
February 19, 2014 02:39PM


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.