>>Can you please re-phrase your question to make it clearer?
>
>Instead of having the following tables:
>
>Member, Choice (6 available choices), MemberChoice (which is the one to many relationship)
>
>I was focusing on having six additional fields in Member instead. So, when doing the query, it would boost the performance. Knowing that this would be used heavily for a ton of searches on a daily basis, I think it would make sense to consider such design.
If you're 100% sure that your design regarding these fields would not change, then you can put the fields into Member table and it will improve the performance. I'm not sure you will get a significant improvement, though.
If it's not broken, fix it until it is.
My Blog