Re: Bad performance on Linked Server

from: Rob Berendt <rob@xxxxxxxxx>
subject: 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
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com