Re: select any row?

Turkbear wrote:
> Bricklen <bricklen_at_zyahoo.zcomz> wrote:
>> try
>> select /*+ first_rows */ * from myview where rownum<2;
>
> Also try
>
> SELECT * FROM MYVIEW WHERE ROWNUM = 1;
>
> But much depends on the view's code..

It might be also a matter of the view´s code but nevertheless, Bricklens tip using the optimizer hint sped up the query very much. I tried using rownum = 1 before but it had no noticable effect :(

Thanks for all your help,
Dirk Received on Tue Nov 02 2004 - 04:34:07 CST