Re: Optimize sub query with large group by
Posted by:
Alex K
Date: March 17, 2011 12:40AM
Oystein your query works however it takes longer and still includes the group by object_id which seemed to be what was taking so long.
I have been testing this on a laptop and hadn't increased the buffer_pool_size much. I checked the IO and most of it was fetching from disk.
Thanks Rick.
I tested the same query on the actual server and it only took 4 sec compared to 120 sec. This is much faster but I'm not sure what I should be expecting the speed to be (could it be faster?).
Still wonder if there is a better way to get the same result with a different query.
Thanks all for the help.
Subject
Views
Written By
Posted
3936
March 10, 2011 07:44PM
2216
March 13, 2011 03:52PM
1922
March 13, 2011 04:59PM
2917
March 13, 2011 11:32PM
2210
March 14, 2011 02:39AM
1680
March 14, 2011 06:31PM
1558
March 14, 2011 07:15PM
1845
March 15, 2011 04:32AM
1625
March 15, 2011 08:46PM
2383
March 16, 2011 02:02AM
2290
March 16, 2011 08:57AM
Re: Optimize sub query with large group by
1650
March 17, 2011 12:40AM
3641
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.