Home » RDBMS Server » Performance Tuning » Sql taking 2min with order by clause
icon14.gif  Sql taking 2min with order by clause [message #268348] Tue, 18 September 2007 05:08 Go to next message
rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai
Member
Hi All,

if i use order by clause with descending order then sql statement taking almost 2 mins otherwise it is taking 650ms.

and i have try to change the position of column in order by clause and on those column index is no index and i don't want to create index on those column.

database version:9.2.0.4.


Thanks in Advance


Ashish
Re: Sql taking 2min with order by clause [message #268368 is a reply to message #268348] Tue, 18 September 2007 06:12 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the sticky "10g - How to Identify Performance Bottleneck", execute what it is adviced and post requested information.

Regards
Michel
Previous Topic: Processing lots of data
Next Topic: outer join problem
Goto Forum:
  


Current Time: Sat Dec 03 01:18:35 CST 2016

Total time taken to generate the page: 0.07283 seconds