> >> 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: [snip] > SYS:BUKA> create view mydual as select * from dual where > rowid='AAAADDAABAAAAHSAAA'; Cool solution, I hadn't thought about the rowid solution before, I have used IOTs and single table hash clusters so far if x$dual isn't an option. Btw, I was wrong before, x$dual DOES exist in 8i as well, at least in 8.1.7.4. Tanel. ---------------------------------------------------------------- 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 -----------------------------------------------------------------