RE: Bad performance on Linked Server

I think openquery may be the answer. I have a monthly reminder to beat me up side the head with a 2x2 to remind me of this:


<snip>
openquery is just MS SQL Server's technique for a "linked server". Some sql engines always do it. Some do it within setup or connection configuration.

openquery:
I assume you're trying to set up a linked server?

https://www-01.ibm.com/support/docview.wss?uid=nas8N1014514

Once you get connected, note the following:

-- Pull all rows from the table(s) back to MS SQL server and do the where
locally
select * from LINKEDSVR.MYIBMI.MYLIB.MYTBL where locnbr = '00335';

-- Sends the statement to linked server for processing
select * from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
''00335''');

--OPENQUERY() isn't just for SELECTS
delete from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
''00335''');
</snip>


Rob Berendt