database - DB table design - multiple columns vs multiple tables -
i have database normalized tables , such. ran situation needed make decision of whether store information 1 table multiple columns or split them several tables.
here's example.
option 1)
table 1) --> planid, periodid, value
table 2) --> planid, periodid, value
option 2)
combined table --> planid, periodid, value1, value2
aside fact option 1 take storage space. downside of using option 1 opposed option 2.
Comments
Post a Comment