MySQL Forums
Forum List  »  General

Re: Query time differences.
Posted by: Rick James
Date: August 26, 2015 10:40AM

`node` needs INDEX(store_id, trans_id) or INDEX(store_id, type_id)

`aspects` needs INDEX(qname_id, node_id) in either order

Options: ReplyQuote


Subject
Written By
Posted
August 25, 2015 05:46PM
August 25, 2015 06:20PM
Re: Query time differences.
August 26, 2015 10:40AM
August 27, 2015 11:16AM
August 29, 2015 11:49AM


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.