Data comparison: mark data not matched if destination doesn't exist or is empty
When performing data comparison, test destination for existence and number of rows before comparing. If destination table doesn't exist or is empty, all data in the source can be marked as not matched, saving the time of the actual compare operation.
1
vote
Dave Nechodom
shared this idea
-
Dave Nechodom
commented
This became glaringly important as I was running a compare on a table with over 200M records to its match in a new location.