Lots of tables in O7
From: <scott_at_chuck.sycraft.com>
Date: 31 May 94 07:50:31 MST
Message-ID: <1994May31.075031.190_at_chuck.sycraft.com>
Date: 31 May 94 07:50:31 MST
Message-ID: <1994May31.075031.190_at_chuck.sycraft.com>
My group is building a critical application. One option is to use many tables for lookup info (carriers, types of things, etc.) all data driven. This is best for the tools we use. Result would be 60+ tables of which 20 would have fewer than 20 rows (lookup stuff). Option two would be to put all of that lookup stuff in one table.
Which is better for Oracle? Any actual experience?
The answer so far is "design a good database and normalize". Yea, ok but lets get real also. Any reality out there?
-- scott scott_at_chuck.sycraft.com Knowledge is Good - Emil Faber 1962Received on Tue May 31 1994 - 16:50:31 CEST