i do BCP on two staging tables . actualy i need to store data in 1500 columns , so i splitted this two table to store 1030 + rest ...
to make synch have to chk these two tables and do update by joining 3 columns . there is no index on this two tables .. this updation happening for 1.40 min .. i created non cluster index on this table for that 3 columns .. but still it takes 1.25 min .. 15 minutes is not much improvement ... atleast it shud run in 30 min .. that is actual improvement ...
there is no complicated qry .. just joining 2 tables with 3 columns .. but data is 3.5 lak.