detached indexes

Posted in 2007

Topics: Storage & Space Management, Server Administration, Versions, Editions & End-of-Life

Robert Roussey\\\\(IT\\\\) — Thu, 19 Apr 2007 22:11:13 — source: IIUG Forums & Mailing Lists

I know I can detach indexes from tables to another dbspace; CREATE UNIQUE INDEX "prod".rlidx_db0_10 ON "prod".db0_10 ( rec_loc ASC ) in maintdbs2; Can I do the same thing with the 'alter table' statement for PKs? ALTER TABLE db0_10 ADD CONSTRAINT PRIMARY KEY ( sta_code ) CONSTRAINT pkey_db0_10; IDS 10.00.UC4 Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com

↪ replying to Robert Roussey\\\\(IT\\\\)

ART KAGEL, BLOOMBERG/ 731 LEXIN — Thu, 19 Apr 2007 22:13:13 — source: IIUG Forums & Mailing Lists

Just create the primary key index first detached to whereever you want it. Then the constraint will use the existing index. Art ----- Original Message ----- From: Robert Roussey <ids@iiug.org> At: 4/19 18:11:36 I know I can detach indexes from tables to another dbspace; CREATE UNIQUE INDEX "prod".rlidx_db0_10 ON "prod".db0_10 ( rec_loc ASC ) in maintdbs2; Can I do the same thing with the 'alter table' statement for PKs? ALTER TABLE db0_10 ADD CONSTRAINT PRIMARY KEY ( sta_code ) CONSTRAINT pkey_db0_10; IDS 10.00.UC4 Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

dbspace