Is it a good idea to merge two tables that have a 1..1 relationship together?
I have inherited a database with too many tables linked together in a 1..1 relationship. I'd like to evaluate the benefits of merging these tables where possible to have more tidy model with higher query performance.
For example table
t1 has 150 records and table
t2 has 150 records, they each contain 5 columns and these two tables have a 1..1 relationship. Would it be a good idea to merge them into one table, say
t3 which contains all the columns from
Also does it make any difference if these tables are reference tables (less than 200 records) or an operational tables?
Any idea is appreciated.