Re: Performance problem with SQL query

And you'll need the first_rows hint on the outer query in addition to the rownum clause...

>One more thought (courtesy of Tom Kyte):
>
> and id in (select * from table(cast(function_x() as id_tab))
> where rownum > 0);
Received on Fri Sep 05 2003 - 18:42:33 CDT