Database Design Best Practice help
From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Mon, 28 Jan 2013 10:03:16 +0100
Message-ID: <51063ED4.7000009_at_sferacarta.com>
Hi all,
Date: Mon, 28 Jan 2013 10:03:16 +0100
Message-ID: <51063ED4.7000009_at_sferacarta.com>
Hi all,
I have a question about database design best pratice.
In my db I have about one hundred tables like this:
code
description
To avoid to have a so great number of similar tables in the db I wonder if it is a good idea to unify all these tables in one big table like this:
id
code
table_ name
description
The advantages are:
- only one table in the db instead of 100
- only one controller to manage the table
Could this be a way to enhance db performance? Is there any negative point that I don't see?
Thanks for any comments.
j
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 28 2013 - 10:03:16 CET