Thanks for the answers

1. Yes it needs to be generated randomly. It's a statistical application and the first rule is everything has to be generated randomly

2. Thanks also for the link. I will do so in my future post.

3. I will check my other queries to make sure that they are optimized.

Thanks again