Re: Optimize sub query with large group by
Posted by:
Rick James
Date: March 14, 2011 06:31PM
GROUP BY object_id -- yet you nowhere else do you mention object_id.
The group-by-trick depends on the inner query having an order by -- that way the GROUP BY at the next level can pick the right row, namely the 'first' row in each grouping.
Another topic to study is "compound indexes".
Subject
Views
Written By
Posted
4011
March 10, 2011 07:44PM
2225
March 13, 2011 03:52PM
1941
March 13, 2011 04:59PM
2931
March 13, 2011 11:32PM
2222
March 14, 2011 02:39AM
Re: Optimize sub query with large group by
1687
March 14, 2011 06:31PM
1571
March 14, 2011 07:15PM
1857
March 15, 2011 04:32AM
1639
March 15, 2011 08:46PM
2397
March 16, 2011 02:02AM
2298
March 16, 2011 08:57AM
1662
March 17, 2011 12:40AM
3651
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.