Hi Briandonor,
I attach you the Estimated Execution plan and the number of rows per table.
According to the execution plan the more expensive statement is:
INSERT INTO @Property
Select * FROM OPENQUERY (ingres2, '
SELECT
propfixed.propref
,propfixed.houseno
, propfixed.proadd1
, propfixed.proadd2
, propfixed.proadd3
, propfixed.propstcde
,mnode.mnodename
, propfixed.mnodecode
FROM propfixedinner join mnode ON propfixed.mnodecode = mnode.code
I don't understand why if the statement is using a join table to bring data froma look up table that only has 20 records. the propfixed table has only 88923 records. Is there any other way to bring data from a look up table?
Thanks a lot,
Nubia