[jira] [Closed] (GEODE-8287) QueryUtils doNestedIterationsForIndex is not applying an index value correctly and causing the entire region to be iterated

["Dave Barnes (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GEODE-8287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dave Barnes closed GEODE-8287.
------------------------------

> 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.12.1, 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)