Re: How to handle primary and foreign key indexes in Informix?

Posted in 1997

rungashi — Sat, 22 Feb 97 20:09:00 — source: Informix-list mailing list archive (1991-1998)

In Article<01bc1ea0$a6a6c840$53c4abcf@bmw318i>, <cayenne@slip.net> writes: > Path: news1.neo.lrun.com!news-out.internetmci.com!news.internetMCI.com!newsfeed.internetmci.com!news.comm.net!news.sprintlink.net!news-fw-6.sprintlink.net!news-fw-12.sprintlink.net!news-pull.sprintlink.net!news.sprintlink.net!news-peer.sprintlink.net!panix!news.mathworks.com!enews.sgi.com!su-new s-feed4.bbnplanet.com!newsfeed.slip.net!owl.slip.net!not-for-mail > From: "Scott Kurinskas" <cayenne@slip.net> > Newsgroups: comp.databases.informix > Subject: How to handle primary and foreign key indexes in Informix? > Date: 19 Feb 1997 20:08:52 GMT > Organization: Cayenne Software > Lines: 9 > Message-ID: <01bc1ea0$a6a6c840$53c4abcf@bmw318i> > NNTP-Posting-Host: sf-pm5-19-83.dialup.slip.net > X-Newsreader: Microsoft Internet News 4.70.1155 > > This should be a simple question for all you Informix gurus out there. > > Is it possible to specify the location (dbspace), size, etc. of primary and > foreign key indexes for Informix, or is it recommended to let the server > automatically generate the indexes for you. > > Thanks, > Scott > cayenne@slip.net To specify the location of a primary or foreign key index, don't specify the primary or foreign key in the create table sql. Create the table. Create the indexes specifying "IN dbspace". Then alter the table adding the primary or foreign key.