Yes, the design of the pages are such that Nolock will have hardly have impact on the users. Anyhow currently i am not looking at the optimization of the queries as such. because before i enter that area i want to make sure that i have server with proper RAM size. If you can help me identify the RAM size which i can confirm with the customer will really help me.