Forum Stats

  • 3,734,269 Users
  • 2,246,935 Discussions
  • 7,857,216 Comments

Discussions

Approach to find the delta records in all the partitions

KVB
KVB Member Posts: 194 Blue Ribbon
edited May 12, 2015 1:17AM in SQL

Hi,

   I have a table with 530 partitions,20 million records in each partition.Most of them are redundant data.I need to find the changed records and insert into a new table.

I have followed the approach but I feel it's more expensive.Could you please throw some light on this.

1)Comparing each partition in a loop and finding deltas

Sign In or Register to comment.