alopeze (10/20/2009)
Now that you are talking something about the WLAN, when i execute this query in the local server the time is 1 second, but when i execute the query in other computer in another office loke 1kilometer from the server the time too bad!.....
So what sort of network do you have between yourself and the server ?
In terms of query tuning , there really is nothing that can be done.
Do you have a realistic expectation of the speed you need, is this a real world production issue ?
You may want to look into one of the replication options.