Re: Indexes ? or Constraints ?

In article <stanbD8E2EI.3E5_at_netcom.com>, stanb_at_netcom.com (Stan Brown) says:
>
> I am in the process of planing a migration from V6 to V7. Our
>V7 creation scripts have both UNIQUE declerations & CREATE UNIQUE INDEX
>comands in them. This of course won't work in 7.0
>
> What I am wondering is which is better ? I am loath to take out
>the constraints clauses, since they document the referntial integrety of
>the tables. Howeve if I leave them in I don's seem to have nay control over
>the storage of the idexes that will be created. We presently put indexes
>in a diferent tablespace (on a different disk) than the tables. Also we
>control fairly tightly the space ocumpied by the indexes (PCTFREE, MIN,
>NEXT etc). I also hate to lose this.
>
> Am I missing something about how to control the auto generated indexes ?What have other people done about this ?
>
>Thanks
>
>
I use the following DDL to maintain RI and control the space and placement of an index:

 ALTER TABLE T00101
    ADD CONSTRAINT X0010101
    PRIMARY KEY(USER_ID)
    USING INDEX PCTFREE 10 TABLESPACE X002

                STORAGE  (INITIAL     3K
                          NEXT        1K
                          PCTINCREASE 0);

Hope this helps.

Nick DiBlasi
DBA
Electronic Data Systems
ahipc1j.ndibla01_at_eds.com