Re: Performance issue with Analytical function

apramodh_at_gmail.com wrote:
> Hi,
>
> I have a query which should run on tables with 40 million rows
>
> To the above query when add the analytical function row_number() for a
> sorting requirement it runs indefinitely. All indexes are being used
> etc. but is continues to run indefinitely. What could be the possible
> reason? What could a developer (no DBA rights on database) do in this
> case.
>

Implicit in Jonathan's suggestion about multipass is: see your DBA about pass executions. The PGA advisor memory usage details in OEM can be an eye-opener.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20060710/news_1n10others.html