Index with SQL Server Linked Tables

S

Sash

I have a SQL Server back end to a database with linked tables. Do I have to
assign and index in Access or will it use what I've already assigned in SQL
Server??
 
R

Rick Brandt

I have a SQL Server back end to a database with linked tables. Do I
have to assign and index in Access or will it use what I've already
assigned in SQL Server??
Click to expand...

Queries against linked tables will send some (sometimes all) of the
processing to the server. Obviously the server will use the index during
processing as appropriate. Access is aware of the indexes that are
defined on the server, but can also make its own local indexes. Those
should not normally be necessary though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coverting linked tables into local tables 2
Access-SQL Server object dependencies 3
Link Access 2000 DB to SQL Server 2000 DB 1
SQL db Linking issues 4
Change linked table destination--Access Link to SQL 2005 1
Retrieving the SQL Server Name of a ODBC Linked Table in Access 20 2
What database am I using? 4
ADO 1

Top