Re: equivalent of 'clustered' (SQL) in ORACLE

b_arlt_at_my-deja.com wrote:
> In article <9439i4$4f8$1_at_nnrp1.deja.com>,
> iluzn_at_my-deja.com wrote:
> > This is what I have written in SQL:
> >
> > create table TEST
> > (ID int primary key clustered,
> > name varchar(30),
> > .....etc)
> >
> > i am unsure of what "clustered" does and how to duplicate its effect
> > within an oracle DB
> >
> > can you help?
 

> The term 'clustered' in MSSQLSvr implies that the data of the table is
> stored as an index which is ordered upon the primary key.
>
> There is a similar construct in Oracle, an index organized table
> (IOT). The use of an IOT, however, comes with severe restrictions
> including the inability to define any other indices on the table. This
> means that >>ALL<< efficient access to the table must be done via the
> primary key. In most cases this is not appropriate.

   In Oracle8i you are able to create other indeces jy index organized table

Valery Yourinsky

-- 
Oracle8 Certified DBA