+ Start a Discussion

Compare large volume of data

I have a unique situation,
I have a 500k records in one table and 100k records in another table, What is the best way to compare the data . I am not sure it is possible using APEX.
  1. Can you elaborate 'compare the data'?
  2. Both the 500k and 100k records belong to the same object?