remote query

Hi ,
Somebody know how to optimize a remote query'More information please.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ricardo De Val Borges" <rdeval@.pop.com.br> wrote in message
news:#4kwFxTMEHA.3380@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> Somebody know how to optimize a remote query'
>|||Hi,
Did you meant tuning the "Query" in remote server (linked server). If is the
case then the tuning remains the same as local server query tuning. Connect
to the remote machine using Query analyzer . How to do that:-
1. Using client network utility create an alias name for the remote server
using the ip and port number
2. Connect to remote server using query analyzer selecting the Alias
created, user name and password
3. Open the query and execute using "Execution Plan'
4. Check query is using the indexes
5. Check query is written in optimized way
Thanks
Hari
MCDBA
"Ricardo De Val Borges" <rdeval@.pop.com.br> wrote in message
news:#4kwFxTMEHA.3380@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> Somebody know how to optimize a remote query'
>