OraFAQ Forum: Performance Tuning » order by makes troubles in my select!

Home » RDBMS Server » Performance Tuning » order by makes troubles in my select!

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

order by makes troubles in my select! [message #65442]

Wed, 22 September 2004 01:14

Milly
Messages: 72
Registered: March 2004

Member

Hi all!

I have a table with 50000 records, with a varchar2(32) primary key, with indexes....

As soon as I add a order by clause, the query gets slower and slower....

any idea?

thanks!

Report message to a moderator

Re: order by makes troubles in my select! [message #65451 is a reply to message #65442]

Wed, 22 September 2004 22:07

Frank
Messages: 7901
Registered: March 2000

Senior Member

How do you test this ?

See http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:9105536363557#9150303878898 for a possible clarification (search for "toad").

hth

Report message to a moderator

Previous Topic:	too slow select.
Next Topic:	Working of ROWNUM?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 31 09:53:23 CDT 2025