On Mon, 2004-07-05 at 05:37, J.Velikanovs@xxxxxxxx wrote: > >> In 8i there is no x$dual, there you could use a single table hash > cluster or IOT with relevant view on it to reduce dual cost (an unique > scan on single block IOT akes only 1 LIO compared to 3 that FTS makes on a > single block table). > You definitely know, but in any case FYI: > > ===================================================== > SYS:BUKA> select rowid from dual; > > ROWID > ------------------ > AAAADDAABAAAAHSAAA > > SYS:BUKA> create view mydual as select * from dual where > rowid='AAAADDAABAAAAHSAAA'; > > View created. ... Clever trick. Just remember that an export/import to another or new database will break it. Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------