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
4239
March 10, 2011 07:44PM
2359
March 13, 2011 03:52PM
2080
March 13, 2011 04:59PM
3049
March 13, 2011 11:32PM
2386
March 14, 2011 02:39AM
1800
March 14, 2011 06:31PM
1702
March 14, 2011 07:15PM
2011
March 15, 2011 04:32AM
1760
March 15, 2011 08:46PM
2513
March 16, 2011 02:02AM
2447
March 16, 2011 08:57AM
Re: Optimize sub query with large group by
1785
March 17, 2011 12:40AM
3788
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.