[
https://issues.apache.org/jira/browse/GEODE-8287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145894#comment-17145894
]
ASF subversion and git services commented on GEODE-8287:
--------------------------------------------------------
Commit a7470632c4dfe0c878a1c9735c183c3300173a32 in geode's branch
refs/heads/support/1.12 from Barry Oglesby
[ https://gitbox.apache.org/repos/asf?p=geode.git;h=a747063 ]
GEODE-8287: Added another condition to cause the indexed value to be used
(cherry picked from commit 827f8651b02d90a8ad7dfa3dca62af3c06ca6b6c)
> QueryUtils doNestedIterationsForIndex is not applying an index value
> correctly and causing the entire region to be iterated
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: GEODE-8287
> URL: https://issues.apache.org/jira/browse/GEODE-8287
> Project: Geode
> Issue Type: Bug
> Components: querying
> Affects Versions: 1.12.0
> Reporter: Barrett Oglesby
> Assignee: Barrett Oglesby
> Priority: Major
> Labels: caching-applications
> Fix For: 1.13.0, 1.14.0
>
>
> Here is an example of the query in 8.2.12:
> {noformat}
> Query Executed in 3.502438E7 ms; indexesUsed(2):mapFieldIndex(Results:
> 500),pkIdIndex(Results: 1) "select vr1, vr2 from /region1 vr1, /region2 vr2
> where vr1.id = vr2.id and vr1.mapField['FIELDNAME']=$1"
> {noformat}
> The number of DistributionStats deserializations is 1,001.
> Here is an example of the query in 9.10.0:
> {noformat}
> Query Executed in 22732.467 ms; rowCount = 500;
> indexesUsed(2):mapFieldIndex(Results: 500),pkIdIndex(Results: 1) "select vr1,
> vr2 from /region1 vr1, /region2 vr2 where vr1.id = vr2.id and
> vr1.mapField['FIELDNAME']=$1"
> {noformat}
> The number of DistributionStats deserializations is 25,001,004
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
