Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
5 years ago

Queries in merging two tables

Good Day, We need to perform a simple activity where I used outer join and merge . The purpose of merge is to actually unite both the tables to proceed further . Since the entries present in the re...
ptaylor's avatar
ptaylor
Employee
5 years ago

Don’t use Outer when doing a 1=1 join. Always use Inner. The result will be the same, by definition, but the performance, both memory-wise and time-wise, will be better with Inner. This advice is based on the details of the implementation of each of these joins.

Harsha3's avatar
Harsha3
New Contributor III
5 years ago

Hi Ptylor,

Thanks for the details it actually worked !.

Thanks Taleski for the updates.