Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
YoungLearning
Helper II
Helper II

Merge types

YoungLearning_0-1717403586409.png


Why is inner join more efficient that left outer, and doesn't this mean we will skip the products with ProductSubCategory with no parent ProductCategory?

1 ACCEPTED SOLUTION
PIYUSHPRAJAPATI
Resolver I
Resolver I

Yes, Left outer join produce the same result

and for the second part i give the answer based on the question was you posted according to that left outer join is answer in the second blank for the second question that assumtion take by us and me and other so only we need inner join or left outer in such cases.

 

View solution in original post

3 REPLIES 3
PIYUSHPRAJAPATI
Resolver I
Resolver I

Yes, Left outer join produce the same result

and for the second part i give the answer based on the question was you posted according to that left outer join is answer in the second blank for the second question that assumtion take by us and me and other so only we need inner join or left outer in such cases.

 

PIYUSHPRAJAPATI
Resolver I
Resolver I

There would be two answers the join kind first question is asked every productcate. has productsubcate. use inner join and in second question Not every productsubcate have productcate so in suct case use left outer join if Productsubcate table on the left hand side and product category table on the right hand side as mentioned in the questions.  

According to the your question there different working of the inner join and left outer join but it's obvious inner join is very effecient and you are right left outer join is used for the second question that mentioned in the above question.

 

Just Click Accept the solution if you got the answer.

First part: If every product has a subcategory and vice versa, wouldn't outer left and inner produce the same results?

Second part: If the objective is to maximise performance, then why should I need to include the subcategories which has no corresponding parent category? There are too many assumptions here.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.