Optimize analytical functions

[sam93]

Hi,

Are there any hints or methods specific to optimizing analytical functions in 9i? I've got a query that runs in miliseconds, but when I add an analytical function (FIRST_VALUE ..... OVER (PARTITION BY ..... ORDER BY ...), the it starts taking more than 10 minutes. The execution plan shows a window sort for it.

Thanks.

 

[sem]

Do you have appropriate indexes? Is your statistics up to date? AFAIK there's no specific way to optimize AF but you may follow common performance tuning practices.

Regards, Dima

http://seminihin.narod.ru

 

[cmmrfrds]

Can you show the SQL statement.