'Running and joining two tables with a 100 million+ rows together

What is the best way to join two tables together which exceed rows of over 100 million rows? I'm running into an issue where my query is timing out after 6 hours?

Has anyone worked with large amounts of data like this before?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source