ROWID, ROWNUM and views
From: <strepxe_at_yahoo.co.uk>
Date: Thu, 26 Jun 2008 23:18:50 -0700 (PDT)
Message-ID: <2b82cd95-d821-4b1f-ac56-b3d5420e4f20@k13g2000hse.googlegroups.com>
Date: Thu, 26 Jun 2008 23:18:50 -0700 (PDT)
Message-ID: <2b82cd95-d821-4b1f-ac56-b3d5420e4f20@k13g2000hse.googlegroups.com>
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 ....