MySQL Forums
Forum List  »  Optimizer & Parser

Re: Please help to optimize slow running query
Posted by: Björn Steinbrink
Date: March 16, 2008 06:31AM

The join with IndividualPolicy in the main query seems to be pretty useless. There's neither a join condition for that table, nor are you using any values from that table. It's just blowing up the result set by a factor of 7050. And, AFAICT without any information about the tables, the GROUP BY clause seems to exist only to hide the effects of that cross join.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Please help to optimize slow running query
2461
March 16, 2008 06:31AM


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.