Re: Index Organized Tables

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 12 Aug 2007 11:17:54 -0700
Message-ID: <1186942673.958620@bubbleator.drizzle.com>

Richard Foote wrote:
> "Rohit" <rpk.general_at_gmail.com> wrote in message
> news:1186894050.144815.146460_at_q4g2000prc.googlegroups.com...

>> 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.
>
> Cheers
>
> Richard

Or when queries will run faster by forcing an optimumal (low) clustering factor.

For a demonstration of how this can affect a query run this demo: http://www.psoug.org/reference/clustering_factor.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Aug 12 2007 - 13:17:54 CDT