How to speed up joins

DocMusher
New Altair Community Member
Hi,
Joining 2 tables based on an id attribute, can take some time.
How could this process be optimized? Do both tables need tobe fully loaded? Even if I would only generatie a join based on one example.
What is the non-coding solution when I might use postgres, mongodb or Cassandra?
Cheers Sven
Joining 2 tables based on an id attribute, can take some time.
How could this process be optimized? Do both tables need tobe fully loaded? Even if I would only generatie a join based on one example.
What is the non-coding solution when I might use postgres, mongodb or Cassandra?
Cheers Sven
Tagged:
0