OraFAQ Forum: Server Administration » Problem with using order by clause in a Query

Home » RDBMS Server » Server Administration » Problem with using order by clause in a Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with using order by clause in a Query [message #56142]

Fri, 07 March 2003 12:20

Anil Mishra
Messages: 1
Registered: March 2003

Junior Member

I am having problem with using a order by clause in one of the Oracle query. The sort area size for the database is of size 1MB. The sort area reatined size is also 1 MB. When I remove the order by clause the query is preety quick but when i specify the order by clause the retrival time shoots up like anything. I tried using perfstat and there are no considerable wait events associated. Can anyone help me out with this problem.

Report message to a moderator