Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Linked server no using indexes

Author  Topic  jhilb Starting Member 22 Posts Posted - 2001-10-30 : 16:25:37 Server 1 and 2 are linked. Server 1 is SQL 7, server 2 is SQL 2000. When doing an update directly on server 2, the update runs fine, execution plan says it is using a clustered index (as it should be). The exact same update, but executed on server 1 (linking to server 2), takes forever to run. Execution plan shows that it is table scanning. What gives? Why would a query run using the clustered index when ran directly on the server, yet when executed across a link it does not?