Re: ROWID, ROWNUM and views
Date: Fri, 27 Jun 2008 21:29:28 +0200
> 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