[
https://issues.apache.org/jira/browse/CALCITE-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandeep Chada updated CALCITE-2671:
-----------------------------------
Description:
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.
was:Use IN SET OQL predicate to improve query performance for Geode
> GeodeFilter change to transform multiple OR s to use IN SET OQL predicate to
> improve query performance for Geode
> ----------------------------------------------------------------------------------------------------------------
>
> 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)
