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

Scott Kurinskas <cayenne@slip.net> wrote in article <01bc1ea0$a6a6c840$53c4abcf@bmw318i>... > 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. 1) Create table(s) WIHTOUT the primary/foreign key constraints. 2) Create indexes corresponding to the primary/foerign keys. Name them as you like and put them in whatever dbspace you like. 3) Use ALTER TABLE to add the primary/foreign key constraints. Putting the primary/foerign key constraints in the CREATE TABLE statement causes the server to generate it's own (meaningless) index names. Worse yet, the index names begin with a space which has been known to cause MS Access (at least some versions) problems. HTH