Re: Slow Full Table Scan on IOT

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 15 Jul 1999 19:59:14 +0800
Message-ID: <378DCD12.2686@yahoo.com>

Joerg Lanzinger wrote:
>
> Hello,
>
> for performance testing I build two tables containing about 1M rows of
> generated data. One table as an IOT, the other with no special
> properties.
> It showed up that performing a full table scan on the IOT takes about
> 200 seconds, while the FTS on the 'normal' table finished after about 10
> seconds.
> (I'm using Oracle 8.0.3 on a Sun Enterprise, Solaris 2.6)
> Any suggestions to explain this phenomena?
>
> Thanks
> Joerg
>
> --
> ___ __
> \_ \ \ \ Joerg Lanzinger, Tankenrainer Str. 33, 82362 Weilheim
> _\ \ \ \__ EMail: joerg.lanzinger_at_in.tum.de
> \___\ \___\ WWW: http://www.in.tum.de/~lanzinge
>
> -=* REALITY.SYS maybe corrupt - Reboot universe (Y/N) ? *=-

Full table scans on "normal" tables can take advantage of the multiple read count (cf: init.ora) of database blocks...

index organised tables cannot.
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 15 1999 - 06:59:14 CDT