Indexes ? or Constraints ?

From: Stan Brown <stanb_at_netcom.com>
Date: 1995/05/11
Message-ID: <stanbD8E2EI.3E5_at_netcom.com>#1/1

        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

--

Stan Brown     stanb_at_netcom.com                                    404-996-6955

Factory Automation Systems
Atlanta Ga.
--

DOS ... is still a real mode only non-reentrant interrupt

handler, and always will be.                -Russell Williams

|------------------------------------------------------------------|
|  Windows, the only computer virus to take up 20 megs of RAM      |
 ------------------------------------------------------------------

Received on Thu May 11 1995 - 00:00:00 CEST