[ https://issues.apache.org/jira/browse/CALCITE-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686488#comment-16686488 ]
Sandeep Chada edited comment on CALCITE-2671 at 11/26/18 5:38 PM: ------------------------------------------------------------------ PR Link [https://github.com/apache/calcite/pull/942] was (Author: chadasa-gs): PR Link [https://github.com/apache/calcite/pull/938] > GeodeFilter change to transform multiple OR s to use IN SET OQL predicate to > significantly improve query performance > --------------------------------------------------------------------------------------------------------------------- > > Key: CALCITE-2671 > URL: https://issues.apache.org/jira/browse/CALCITE-2671 > Project: Calcite > Issue Type: Improvement > Components: geode > Reporter: Sandeep Chada > Assignee: Julian Hyde > Priority: Major > > In Geode when we are querying thousands of rows using an IN query, IN SET > query predicate gives high query performance than multiple OR s. > I am making the change in the GeodeFilter translateMatch function by first > checking if IN SET is applicable then only use it, otherwise the multiple OR > code is called. -- This message was sent by Atlassian JIRA (v7.6.3#76005)