OraFAQ Forum: Performance Tuning » Sql taking 2min with order by clause

Home » RDBMS Server » Performance Tuning » Sql taking 2min with order by clause

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

Sql taking 2min with order by clause [message #268348]

Tue, 18 September 2007 05:08

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

Report message to a moderator