Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Slow Full Table Scan on IOT
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) ? *=-Received on Thu Jul 15 1999 - 03:23:47 CDT