Re: Optimize sub query with large group by
Posted by:
Alex K
Date: March 15, 2011 08:46PM
Thanks Oystein,
I was aware that the group by was just using the fact that the implementation chooses the first one. However this does not answer my question as to how to speed the query up.
The problem I am trying to solve is that the current implementation IS working but is just too slow. It takes several minutes to complete when the events table contains 10 million rows.
How would you suggest I rewrite the query to get the same result without using a quirk of the group by implementation. And is the new query any faster than the one I am using.
If there is no way to improve the speed of this query, Am I just going to have to live with the fact that it takes several minutes.
Subject
Views
Written By
Posted
3895
March 10, 2011 07:44PM
2190
March 13, 2011 03:52PM
1899
March 13, 2011 04:59PM
2897
March 13, 2011 11:32PM
2190
March 14, 2011 02:39AM
1658
March 14, 2011 06:31PM
1539
March 14, 2011 07:15PM
1824
March 15, 2011 04:32AM
Re: Optimize sub query with large group by
1603
March 15, 2011 08:46PM
2359
March 16, 2011 02:02AM
2262
March 16, 2011 08:57AM
1624
March 17, 2011 12:40AM
3624
March 18, 2011 10:58AM
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.