Remote table hint example needed for simple join

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Maryam (maryamafzal_at_hotmail.com)
Date: 05/11/04 

Date: 11 May 2004 01:59:52 -0700

Could someone explain how an inner join can be rewritten to
incorporate a remote table hint in the select statement where a local
table is being joined to table on a linked server and the select needs
to run on the remote table.

original sql (all happening locally)
SELECT Books.Title, BookOrders.OrderID
FROM Books INNER JOIN BookOrders ON Books.TitleID = BookOrders.TitleID

I have created a linked server called TESTLINKEDSERVER AND it has a
jet 4.o oledb datasource and contains the bookorders table.

I am not sure how to rewrite the original sql statement so that i
incorporate the linked server and perform the join on the linked
server using the remote table hint.

Could someone please help.
Maryam

Relevant Pages

  • Re: Remote table hint example needed for simple join
    ... Are you trying to do a locking/index ... hint on a remote table? ... data in tables from a database in a linked server can be ...
    (microsoft.public.sqlserver.programming)
  • Re: driving_site and local function call
    ... Therefore hint DRIVING_SITE is used to make the query happen on the ... inner join table2@remotedb on ... when the function call is uncommented the query is happening locally. ... evaluated at the remote db, so Oracle has to transfer the working set ...
    (comp.databases.oracle.server)
  • Re: driving_site and local function call
    ... I've got this query accessing a lot of remote data via database link. ... Therefore hint DRIVING_SITE is used to make the query happen on the ... inner join table2@remotedb on ...
    (comp.databases.oracle.server)
  • Re: Remote Proc Restore Fails
    ... Hi - Found the issue - the linked server has a query timeout connection ... > Hi - I have exactly the same problem, with the standby database in a ... > run from the remote server does it seem to fail. ...
    (microsoft.public.sqlserver.server)
  • Re: Update external database
    ... > Thank you for yoru reply, unfortunately I believe I might not have ... >But when I run this I get a syntax error and it points to 'INNER JOIN'. ... to update the local table instead of the remote table. ...
    (microsoft.public.access.queries)