Hi There,
We are in the process of designing a database for a big application
and so far we have designed all the tables almost fully normalized.
There are lot of tables which are having one to one relationships and
that to mandatory (i.e. parent and child will always have the
records). To reduce the joins, should we merge these tables into one
instead of two or more tables (one to one). Any idea/suggestion ?
Most of the tables which have very minimal Insert/update/delete
operations but the mostly used to fetch the data, would there by any
performance impact on these tables if there are more than 120 columns
in the tables ? If so then these should be logically divided into
multiple tables with one to one relationship.
I appreciate if someone can help me on this topic.
Regards
Satya