Update - Linked Server
I am trying to execute an update statement against a table available through linked server
(used sp_addlinkedserver and sp_addlinkedsrvlogin to configure linked server).
But to execute this query it takes more than 30 minutes, where as when executed on the
remote server directly takes only 1 second.
Set Fa_Enigma_Id = Cu_Customer_Id
Where TableAA.Fa_facility_No = TableBB.cu_gatsid
And TableAA.Fa_Enigma_Id IS NULL
And TableAA.ZZ_Location = 'UK'
Please note that TableAA is a table available on remote server and TableBB is a table in
local database where the query is executed.
Further Info, TableAA has 6000 records and TableBB has only 393 records.
Please help to improve the performance.
Thanks & Regards