Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: altering table to make it "organized index"

Re: altering table to make it "organized index"

From: K Stahl <BlueSax_at_Unforgetable.com>
Date: 2000/04/19
Message-ID: <38FDA1F2.4069E260@Unforgetable.com>#1/1

Niall Litchfield wrote:
>
> Hi
>
> This is filched directly from the documentation for 8(i)
>
> Index-organized tables are like regular tables with a primary key index on
> one or more of its columns. However, instead of maintaining two separate
> storage spaces for the table and B*tree index, an index-organized table only
> maintains a single B*tree index containing the primary key of the table and
> other column values.

Thanks. Received on Wed Apr 19 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US