AnsweredAssumed Answered

How can i process the data faster when I use multiple joins and hitting sql server?

Question asked by Shankar Panda on Feb 15, 2018
Latest reply on Feb 16, 2018 by Johan Hammink

HI All,
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.

Outcomes