its simple...answer this question
1) will you search by age? if so how frequently?
Let me explain cluster first
"a clustered index basically contains the actual table level data in the index itself." - So consider this to use it for identity(what makes you unique, but that none should have). If you use your age field as cluster what will happen?
commented on Dec 8 2014 12:36PM