Re: Index Organized Tables

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 13 Aug 2007 09:43:20 GMT
Message-ID: <1186998192.359246@proxy.dienste.wien.at>

Richard Foote <richard.foote_at_bigpond.nospam.com> wrote:

>> When to use Index Organized Tables (IOT) and on what type of tables?

>
> Simplistically, when a table is going to be indexed by an index that is
> going to contain all or most of the table columns anyways and the overheads
> associated with any required secondary indexes doesn't put you off.

For example, when you have a table that implements a m:n relationship between two tables, and whose only columns are the primary keys of the respective tables.

Yours,
Laurenz Albe Received on Mon Aug 13 2007 - 04:43:20 CDT