Suppose I have 2 tables: users and score
In 'users' there is a PRIMARY key called 'user_id'. In 'score' there is a 'score' column and a 'user_id' column.There will be multiple scores for each 'user_id'. My question is whether I should make 'user_id' in the score table an index. Or is there something else I should do?
Thanks,
Doug
In 'users' there is a PRIMARY key called 'user_id'. In 'score' there is a 'score' column and a 'user_id' column.There will be multiple scores for each 'user_id'. My question is whether I should make 'user_id' in the score table an index. Or is there something else I should do?
Thanks,
Doug