Re: table storage

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 4 Mar 2000 20:49:12 -0000
Message-ID: <952203080.2945.0.nnrp-04.9e984b29@news.demon.co.uk>

A minor point -
secondary indexes on IOTs are supported in 8.1.5

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

markp7832_at_my-deja.com wrote in message <89rol8$mf6$1_at_nnrp1.deja.com>...
>
>
>I think Aravind provided the correct answer. An IOT is the only Oracle
>table format that really causes the physical data to be stored in a
>specific predictable physical order. A full tablescan on an IOT
>returns all rows in key order, but secondary indexes are not
>supported.
Received on Sat Mar 04 2000 - 14:49:12 CST