Re: Use of Domain/Foreign Keys

Posted in 1997

Richard Stanford — Thu, 10 Jul 1997 11:18:16 -0500 — source: Informix-list mailing list archive (1991-1998)

On 10 Jul 1997, Robert Owens wrote: > I have a table with about 20 columns. Ten of the columns are 2 character > codes that have associated tables with the valid codes and descriptions. > There are 300,000 records in the first table and from 10 to 100 codes in > each of the other tables. How will you be accessing this data? If you're always going to know the first field in a query, then index that and don't worry about the others. If not... well... you're going to have some delays in all likelyhood. I don't see how splitting this out further would help you at all, personally. -Richard