Home » RDBMS Server » Performance Tuning » order by makes troubles in my select!
order by makes troubles in my select! [message #65442] Wed, 22 September 2004 01:14 Go to next message
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!
Re: order by makes troubles in my select! [message #65451 is a reply to message #65442] Wed, 22 September 2004 22:07 Go to previous message
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
Previous Topic: too slow select.
Next Topic: Working of ROWNUM?
Goto Forum:
  


Current Time: Wed Feb 28 04:47:11 CST 2024