Re: Table design questions?
Posted by:
AtinLango
Date: March 23, 2006 05:48AM
There are many issues involved here. I will highlight only one without touching NORMALIZATION, etc.
In option 1, for every new record that you add, you have the NULL hence wasted space. Imagine if you have several thousands of records.
For option 2, although initially you are creating many tables, in the long run you are not wasting space (in NULLs) because every new record just fits. Infact in option2, i would have 4 tables (persons, books, songs and movies). The last three would be related to persons table.
Subject
Written By
Posted
Re: Table design questions?
March 23, 2006 05:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.