Re: ROWID, ROWNUM and views
From: Marcin Wróblewski <m_wroblewski_at_gazeta.pl>
Date: Fri, 27 Jun 2008 21:29:28 +0200
Message-ID: <g43f0h$m9e$1@inews.gazeta.pl>
Date: Fri, 27 Jun 2008 21:29:28 +0200
Message-ID: <g43f0h$m9e$1@inews.gazeta.pl>
strepxe_at_yahoo.co.uk pisze:
> Here's some advice for you about the pseudo-columns ROWID, ROWNUM and
> their behaviour with views.
>
> * As a general rule avoid using ROWID espcially with complex views
> made up of multiple base tables where a DISTINCT clause is used. The
> DISTINCT clause will result in the SELECT statement with ROWID not
> returning anything.
> * As another general rule avoid using ROWNUM. Have found that if the
> view has an ORDER BY in the inner query then the SELECT return with
> ROWNUM is very very slow ....
>
Could you give some examples? Received on Fri Jun 27 2008 - 14:29:28 CDT