Xref: alice comp.databases.oracle.server:57448 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!dispose.news.demon.net!demon!ayres.ftech.net!news.ftech.net!bignews.mediaways.net!blackbush.xlink.net!news.csl-gmbh.net!informatik.tu-muenchen.de!not-for-mail From: Joerg Lanzinger Newsgroups: comp.databases.oracle.server Subject: Slow Full Table Scan on IOT Date: Thu, 15 Jul 1999 10:23:47 +0200 Organization: Technische Universitaet Muenchen, Germany Distribution: world Message-ID: <378D9A92.D59177BD@in.tum.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.6C-SGI [en] (X11; U; IRIX 6.5 IP22) X-Accept-Language: en Lines: 21 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@in.tum.de \___\ \___\ WWW: http://www.in.tum.de/~lanzinge -=* REALITY.SYS maybe corrupt - Reboot universe (Y/N) ? *=-