Look Up Tables

[dhulbert]

I currently have a large number of lookups, some are being done within scripts as case statements and some using lookup tables.

I'm thinking about changeing them all to use a lookup table to make the maintenance easier etc but just a quick question.

Is it better to use a seperate table for each data element or is it more efficient to use a single table for all

So have a table with the columns

Element   Code  Description
xx        001   Item 1
xx        002   Item 2
yy        OO1   Item2-1

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[r937]

what you're asking is whether to design a One True Lookup Table (OTLT)

google that phrase and you will find that the answer is no



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon