Increase the speed of Join/Merge Queries?

[Anonymous]

I have been working on a project, and the data is coming from 2 different table having 50 thousand plus rows. I have to combine them using Inner Join but it takes eternity to complete that. I tried the Many to Many relationships too but in the end it does not give the correct answers. 

So, can any one suggest, how to speed up the Inner Join or any alternative to get the results faster?

[amitchandak]

@Anonymous , Inner join on number keys 1-M should be fastest.

Can you share sample data of keys and what kind of join you want.

[Anonymous]

For example this. Want to Inner Join on DatasourceId on both tables and M:M relationship is not working correctly

[amitchandak · Accepted solution]

@Anonymous , Unless most needed. One should merge these tables. You can create bridge tables and join those with these two table and use them to display common data

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

https://www.seerinteractive.com/blog/join-many-many-power-bi/

[Anonymous]

Thanks a lot