On Wed, 2004-04-28 at 11:12, Jacques Kilchoer wrote: > Oracle8i Concepts Release 2 (8.1.6) A76965-01 > > 10 Schema Objects > > Secondary Indexes on Index-Organized Tables > Secondary index support on index-organized tables provides efficient access > to index-organized table using columns that are not the primary key nor a > prefix of the primary key. Ah, I didn't know. I have obviously not used a secondary index on an IOT. Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------