MySQL Forums
Forum List  »  Optimizer & Parser

Re: how to optimize this sql?
Posted by: Peter Brawley
Date: July 08, 2016 10:59AM

"Using index condition" would be better than "Using where". Is idx_coupid not on coupon_info_id? If not, did you try adding a covering index on coupon_info_id?

It's a big result set. What will you be doing with 47K rows? What performance gain do you get by leaving off the Order By clause? If that effect is large, try adding gmt_modified to the coupon_indo_id index.

For more help we'd need to see the result of Show Create Table legend_account_coupon, table row count, MySQL version, RAM available, nnodb_buffer_pool setting if it's InnoDB.

Options: ReplyQuote


Subject
Views
Written By
Posted
1345
h h
July 07, 2016 07:38PM
Re: how to optimize this sql?
930
July 08, 2016 10:59AM
908
h h
July 12, 2016 09:01PM
838
July 09, 2016 11:04PM
838
h h
July 12, 2016 09:08PM
805
July 14, 2016 12:52PM


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.