MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Very slow query, and, and, and...
Posted by: Rick James
Date: January 05, 2015 05:56PM

Although you may be implementing the many-to-many relationship in a "proper" way, the inefficiency of it may be hurting. I suggest that when there is nothing exciting the dimension table, don't bother to have such. For example, instead of
custcomb_2_tags: cctg_id, cc_id, tg_id
tags : tg_id, tg_code
have simply
custcomb_2_tags: cctg_id, cc_id, tg_code

Or, this may help:
optimizer_search_depth = 1

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


Subject
Written By
Posted
Very slow query, and, and, and...
Gerrit Andresen
January 05, 2015 08:22AM
Re: Very slow query, and, and, and...
Peter Brawley
January 05, 2015 12:42PM
Re: Very slow query, and, and, and...
Rick James
January 05, 2015 05:56PM
Re: Very slow query, and, and, and...
Gerrit Andresen
January 06, 2015 05:11AM
Re: Very slow query, and, and, and...
Peter Brawley
January 06, 2015 12:00PM
Re: Very slow query, and, and, and...
Rick James
January 06, 2015 02:16PM


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.