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?