Perform a big join on URLs

[dcortell]

Hi

I have on one side a multi million records table including email sent with related URLS included. On the other, a smaller table where for each URL there is a label associated. The join on URLS is time intensive, so wondering if there is any trick I can use to speed up performances. I already sorted the tables per URLS. Bests

[Kurt_Bremser · Accepted solution]

1. Create a format
2. Use a hash object

Both methods require that the smaller dataset fits into available memory.