MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Slow query. Why is it slow?
Posted by: Rick James
Date: May 19, 2013 10:05PM

I see `products_table`, but not `products_status` in that link.

Have you tried the INDEX I suggested? It _may_ do a lot better than the "index merge intersect" that you are getting now.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Slow query. Why is it slow?
ben jaz
May 19, 2013 06:35AM
Re: Slow query. Why is it slow?
Keith Larson
May 19, 2013 08:29AM
Re: Slow query. Why is it slow?
Peter Brawley
May 19, 2013 11:30AM
Re: Slow query. Why is it slow?
Rick James
May 19, 2013 06:27PM
Re: Slow query. Why is it slow?
ben jaz
May 19, 2013 06:34PM
Re: Slow query. Why is it slow?
Rick James
May 19, 2013 10:05PM
Re: Slow query. Why is it slow?
ben jaz
May 19, 2013 10:51PM
Re: Slow query. Why is it slow?
Phillip Ward
May 20, 2013 09:00AM
Re: Slow query. Why is it slow?
Rick James
May 20, 2013 11:20PM
Re: Slow query. Why is it slow?
ben jaz
May 23, 2013 06:21PM
Re: Slow query. Why is it slow?
Rick James
May 23, 2013 08:22PM
Re: Slow query. Why is it slow?
ben jaz
May 26, 2013 01:28AM
Re: Slow query. Why is it slow?
Rick James
May 27, 2013 10:02AM
Re: Slow query. Why is it slow?
ben jaz
May 29, 2013 04:47PM
Re: Slow query. Why is it slow?
Rick James
May 29, 2013 10:31PM
Re: Slow query. Why is it slow?
ben jaz
June 02, 2013 06:05AM
Re: Slow query. Why is it slow?
Rick James
June 02, 2013 12:55PM
Re: Slow query. Why is it slow?
ben jaz
May 20, 2013 12:01AM
Re: Slow query. Why is it slow?
ben jaz
May 20, 2013 05:48AM


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.