All, I have a linked Server to Oracle DB. There is a table which has XML Documents, EID, Created_Date. It has some 100,000 XML Documents I already manually loaded in to SQL.
Now, I have to create a procedure that runs weekly to update SQL DB. Every week the ORA(Link Server) is refreshed. Now I do not want to reload the whole table again and again. So i though using OpenQuery and say where EID not in SQL then take only those
records. (Average New XML Documents every week 10,000). When I run thie EID not in SQL DB its taking so much time for only 10,000 records. Any suggestions are welcome to load on a regular basis in lesser time. Thanks
View Complete Post