Hi,
I have loaded data from a table with 1.3 Billion records into a new table which I have partitioned indexes to improve performance in our data warehouse.
However as I had to run the load over a few weeks I now need to update any records in Table 2 that have changed since the 1st load was done.
I could use an UPDATE with a Join but as both tables have 1.3 Billion rows this could be problematic.
I wonder if I could use the tablediff utility on tables of this size - would anyone know the possible issues during the running of the utility?
Thanks for your help!
JK