Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Join Types not supported by Query Folding

Hi,   Been struggling with this for a while as there seems to be very limited documentation on Query Folding, but from what I've read it seems like all types of joins should be supported by query f...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Anonymous,

 

You could have a reference of this blog which introduces the query folding in more details.

 

Best Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Cherry,

 

I have read through the blogs a few times to find the solution, but none of them I could find mention there being issues with certain join types. Can't see any mention of why a Left Outer would query fold while no others would?

 

Thanks,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Imke,

       

      Sorry I only saw your reply today. It is correct though, it does Query fold at the end!. The individual step itself still doesn't though, very odd. If creating the steps one by one this was an issue as it had to download all the rows before I could continue. Not sure whether to use inner joins with this issue or continue with left join, expand and filter. Will probably need to test which returns best performance.