Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When you say "will always be filled", do you mean lot of inserts. what is scope of data growth?
–
user31045Nov 27 '13 at 20:56

@madhu there will always be a kind of 1 to 1 mapping from Id to the 10 fields. you always have these 10 fields with values. you could have over 100,000 Id (if not millions)
–
FredouNov 27 '13 at 20:59

@madhu these 10 fields will be heavily read from the user interface, update could happen but not often
–
FredouNov 27 '13 at 21:01

Question: will you want to do calculations across the 10 columns? For example, average of the 10 values or sum/min/max of the 5 values per selector, etc.? If you will have such queries, just write - as an exercise - the query that finds for every ID, the selector (1 to 5) and type (1 to 2) with the highest value, using both designs.
–
ypercubeFeb 27 '14 at 9:53