Skip to Content
0
Former Member
May 12, 2013 at 06:41 AM

Join of two very large files

26 Views

Hi,

We are trying to join two large files (one of 23GB - ~180M lines and the other 7GB - ~55M lines)

Join is done on a single field, and both files contains large objects (CLOB) fields

After 13 hours ~40M records where inserted into target table (which is abount 20%)

Does this make sense?

Is there a better approach to deal with large files?

Thanks,

Amir