You are viewing a plain text version of this content. The canonical link for it is here.

Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/10/18 01:58:58 UTC

[GitHub] [arrow-datafusion] AssHero commented on pull request #3862: put subquery's equal clause into join on clauses instead of filter cl…

AssHero commented on PR #3862:
URL: https://github.com/apache/arrow-datafusion/pull/3862#issuecomment-1281709691

   > Great result @AssHero
   > 
   > I think we'll have to do two things
   > 
   > * make sure q2 is really faster (probably: yes)
   > * I think uncorrelated subqueries might be slower after the rewrite, can we avoid doing this for them?
   
   We can just do this optimization for correlated subqueries. For uncorrelated subqueries, filter clause may be better than inner join.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org