Re: Having problems with ORDER BY COUNT
Posted by:
Toa Sty
Date: January 15, 2007 08:28AM
Not sure about this one. When I try something similar to the parent, the order by isn't making any difference. With any largeish number of rows in the table (eg 100K) I get multi-second results anyway. (On 5.0.22)
Can you post explain plans in [ code ] tags for the query with and without the order by?
Toasty
-----------------------------------------
email: 'toasty'*3 at gmail
Subject
Views
Written By
Posted
14355
April 29, 2006 08:56AM
5142
January 15, 2007 03:35AM
Re: Having problems with ORDER BY COUNT
4766
January 15, 2007 08:28AM
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.