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

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -