Re: altering table to make it "organized index"

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.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"K Stahl" <BlueSax_at_Unforgetable.com> wrote in message
news:38FC4F46.20078BE1_at_Unforgetable.com...


> Niall Litchfield wrote:

> >

> > Two things.

> >

> > 1. Are you sure that the full table scan is bad. How many blocks does

 the


> > data in the table fit into. If it is relatively few then a FTS may be

 better


> > anyway. Assuming that you are running Oracle 8.05 or above then the cost

> > based optimiser is *generally* pretty efficient. (CUE host of replies

> > telling me how wrong I am).

> >

> > 2. You appear to be suffering from a misunderstanding of what

 'organisation


> > index' means. This statement creates an Index Organised table. This is a

> > different fish altogether to a table and an index.

> >

> > 3. OK so I can't count... If you really must have indexes used alter the

> > optimser to the rule based optimiser. (or delete all your statistics)

> >

> > HTH

>

> I've been in the 7.3 world up to now so haven't had an opportunity to

 learn


> about 8 yet. What is an "index organized table"?