Re: ROWID, ROWNUM and views

From: Marcin Wróblewski <>
Date: Fri, 27 Jun 2008 21:29:28 +0200
Message-ID: <g43f0h$m9e$> 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

Original text of this message