OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Tunning

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

Tunning [message #20621]

Fri, 07 June 2002 14:13

shankar
Messages: 29
Registered: January 2002

Junior Member

Hello,
I have a query which runs in 100 msc without the order by clause. But as soon as I add the order by clause, it's running for 19 seconds.

any suggestion to make it faster?

Report message to a moderator

Re: Tunning [message #20622 is a reply to message #20621]

Fri, 07 June 2002 14:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try increasing
sort_area_size and sort_area_retained_size in you initsid.ora

Report message to a moderator

Re: Tunning [message #20629 is a reply to message #20621]

Sun, 09 June 2002 19:57

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Try Creating Index on the column used in order by clause.

ManishM.

Report message to a moderator

Previous Topic:	Join Query
Next Topic:	Re: Hierarchical List

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:42:59 CDT 2024