Re: Slow Full Table Scan on IOT

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 15 Jul 1999 21:16:04 +0100
Message-ID: <932070541.26713.1.nnrp-13.9e984b29@news.demon.co.uk>

Try putting in the INDEX_FFS hint (there may be an init.ora in 8.0.3 to enable it with the hint) and see what the difference is - INDEX_FFS will use a multiblock read.

Of course, you can still expect the IOT to be slower (by about 5% possibly) since it uses more space than the table due to the need for branch blocks.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Connor McDonald wrote in message <378DCD12.2686_at_yahoo.com>...
>Joerg Lanzinger wrote:
>> 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.
>
>Full table scans on "normal" tables can take advantage of the multiple
>read count (cf: init.ora) of database blocks...
>
>index organised tables cannot.
>--
Received on Thu Jul 15 1999 - 15:16:04 CDT