Hi all
I want to insert in my local table from a remote table where the values dont exist in local table like below -
insert into local_table
select * from remote_table@dblink a where not exists (select1 from local_table b where a.columna=b.columna);
data to be inserted is more than 220 illion rows, issue is, it is taking lot of time
what hints should I use to improve performane? Should i first create a copy of remote table in my database or any other way?