1. Do you have indexes on those tables.

Answer: Yes we do have indexes on these tables,

2. When did you update your indexes and statistics last.

Answer: I have rebuild these indexes now.

3. Do you have any other processes or blockings while select or update is going on these tables

Answer: How to check whether any processes of blockings while select or update is going on these tables.

4. Did you study the query plan . you can find out what exactly is happening in your query plan if you dont have any blockings etc..

Answer: No, i havent studied the query plan. Please let me know how to study the execute plan.

Thanks for the help.

With Regards

Dakshina Murthy