[ https://issues.apache.org/jira/browse/GEODE-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15142880#comment-15142880 ]
ASF subversion and git services commented on GEODE-730: ------------------------------------------------------- Commit d232e25947a8e223f35feb1feffe3150875dc5f5 in incubator-geode's branch refs/heads/feature/GEODE-17 from [~huynhja] [ https://git-wip-us.apache.org/repos/asf?p=incubator-geode.git;h=d232e25 ] GEODE-730: Optimize single filter join queries When executing a join query with additional filters on a single region, we now detect this scenario and instead of creating a CompositeGroupJunction, we create a regular GroupJunction. When we being cutdown and expansion, we then create new compiled comparisons so that we can do an index lookup. For example "select * from /region1 a, /region2 b where a.name = "joe" and a.id = b.id" We will now execute the a.name first assuming an index is present on a.name During cutdown and expand, we determine that the comparison a.id = b.id can create a new compiled comparison because the alias a from a.id matches our original filter a.name. We can evaluate a.id at this point, say id evaluated to 8. So we create a compiled comparison of b.id = 8. We can now do a lookup using the index on b.id. We retrieve these results and place them into a map. This map will be used to continue to derive additional joins if they exist. Such as b.id = c.id, etc... We can continue with the iteration but instead of iterating the entire b region, we can now go over derived results. This also includes a fix to not unlock an index lock when reevaluating an inner query. > Optimize single filter join queries > ----------------------------------- > > Key: GEODE-730 > URL: https://issues.apache.org/jira/browse/GEODE-730 > Project: Geode > Issue Type: Bug > Components: querying > Reporter: Jason Huynh > Assignee: Jason Huynh > > Currently single filter join queries create a lot of garbage and do the join > before pruning from the filter. We can optimize this for specific cases to > prune prior to joining and only join values that have already passed the > filters. -- This message was sent by Atlassian JIRA (v6.3.4#6332)