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
3904
March 10, 2011 07:44PM
2197
March 13, 2011 03:52PM
1903
March 13, 2011 04:59PM
2901
March 13, 2011 11:32PM
2196
March 14, 2011 02:39AM
1662
March 14, 2011 06:31PM
1544
March 14, 2011 07:15PM
1828
March 15, 2011 04:32AM
1609
March 15, 2011 08:46PM
2362
March 16, 2011 02:02AM
2267
March 16, 2011 08:57AM
Re: Optimize sub query with large group by
1629
March 17, 2011 12:40AM
3629
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.