Re: Multiple indexes

Posted in 1997

Jorge Torralba — Mon, 14 Apr 1997 08:54:42 -0400 — source: Informix-list mailing list archive (1991-1998)

Jeff Cerrafon wrote: > > Here is my problem definition: > > I have a table CUSTFILE with the following fields: > custno number(10) > firstname char(30) not null > lastname char(30) not null > login_name char(8) not null > > I have the following Indexes for CUSTFILE: > Index_1 unique (custno, login_name) > Index_2 non-unique (lastname) > Index_3 non_unique (firtname) > Index_4 unique (login_name) > Oh, one more thing, how about... Index_1 unique (custno, login_name) -- Jorge Torralba Intel Information Technology HF2-71 (503)696-4587 5200 NE Elum Yung Parkway Hillsboro, Or 97124 ===================================================== Any views or opinions expressed by me do not reflect those of Intel Corp.