Re: Individual Type Code tables vs. one big one
Date: 1996/11/05
Message-ID: <55mbr0$j6d_at_wormer.fn.net>#1/1
Kevin Merritt <kevinmerritt_at_earthlink.net> wrote:
>Is there really a significant performance difference between keeping a bunch of small type code
>look up tables (ie 30 of them) vs. keeping just one big type code table with some sort of column
>that tells which type code it is? Any insight is appreciated.
These kinds of tables (the valid code tables with a column telling you what kind of code it is) are insidious. Never let them be created. Sooner or later some smart-aleck programmer will abuse it because he doesn't know how (or doesn't want to) ask for another table. Once you get business data coded into one of these things it will be like pulling teeth to get it out.
Referential integrity can not be applied to these things because you cannot put a 'where' clause in a constraint.
'Keystroke'
KeystrkTX_at_AOL.COM
Received on Tue Nov 05 1996 - 00:00:00 CET