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
Messages: 39
Registered: June 2005
Location: mumbai
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:

Thanks in Advance

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: 65079
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.

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

Current Time: Thu Jul 20 19:59:17 CDT 2017

Total time taken to generate the page: 0.14503 seconds