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

Posted in 1997

Clem Akins — 21 Feb 1997 13:08:30 -0500 — source: Informix-list mailing list archive (1991-1998)

>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. See the entry for "CREATE INDEX" in the "SQL Quick Syntax Guide" v7.1 (part no 000-7631B) July 1995, page 25. Also the other FMs, especially the Tutorial (which is a reference work of art, and not just a tutorial, IMHO.) ______________________________________________________ Clem Akins (aka clema@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: dodging taxicabs in New York City