Re: Indexes and Constraints

I think it's also important to define a separate tablespace for indexes, for efficiency reasons. Otherwise, Oracle will create the indexes in the same tablespace as your data. My preference is to have separate DDL statements for the creation of primary keys or indexes viz:

ALTER TABLE <tablename> ADD CONSTRAINT PK_<tablename> PRIMARY KEY (<f1>, <f2>,..<fn>) USING INDEX TABLESPACE <index tablespace name>;

Regards,
Simon.

Please send your replies to angsy_at_pacific.net.sg

"Bruce Ostrover" <bruceo_at_bellatlantic.net> wrote in message news:y37V6.13687$nf.5160629_at_typhoon1.ba-dsg.net...
> All,
>
> If you have a constraint defined for a table (like the one below), and we
> are using Oracle 8.15 .. then does Oracle create an index for you, or do
 you
> need to create one explicitly
>
> constraint PK_TAXCALC primary key (TAXCALCID),
>
> Regards,
>
> Bruce
>
>
>
>
Received on Mon Jun 18 2001 - 17:20:16 CEST