MySQL Forums
Forum List  »  Performance

Re: Explain
Posted by: Jeremy Smyth
Date: March 06, 2013 11:59AM

This is difficult to do without knowing which of the columns belong to which table. Optimizing queries is frequently a matter of creating the correct indexes, and in this case you're performing that query against the fields "owner" and "status" in one or both tables.

To start with: If they're in the same table, consider creating a composite index on both fields. If they're in separate tables, index them separately and see what improvements you get.

Judicious use of the EXPLAIN statement will also show you how the optimizer is interpreting your statement.

Options: ReplyQuote


Subject
Views
Written By
Posted
1329
March 06, 2013 07:20AM
Re: Explain
717
March 06, 2013 11:59AM
635
March 11, 2013 01:43AM


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.