thanks Alan Burstein,Gail Shaw for you feedback , my point was the same query will perform differently when i execute that in local pc and in server , i will move for separating the server due to load of users on server hard drives,processor,memory and heavy report generations crystal report and etc.. and see how it works.