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>


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 ....
Received on Fri Jun 27 2008 - 01:18:50 CDT

Original text of this message