I am joining 6 tables and writing the results to a target table in SQL server. One of the base table has data over:14702380 records. I tried 3 options.
1. Placed the sql query in the table input and tried to run. It took more than 45 minutes
2. Used merge join 5 times , this took more than 1 hour
3. Used multiway merge join, this gave me out of memory exception.
Can anyone help me on how can i process the data faster in this case.