Foreign key indexing.

Posted in 1994

Igor G. Popov, LOIS Ltd. — Mon, 25 Jul 94 18:26:19 +0600 — source: Informix-list mailing list archive (1991-1998)

Hello, Informixers! I know, it is helpful to create unique index on primary key and duplicative index on foreign key. This is my question: is it useful to create indexes on each component of the composite foreign key, if there is a composite index on the hole key already? Thanks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Igor G. Popov . Laboratory of Open Information Systems, ltd. . . res@lois.perm.su . Russia, Perm, Kirova 128-770, +7-3422-395028 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .