Barrett Oglesby created GEODE-8287:
--------------------------------------
Summary: 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
Reporter: Barrett Oglesby
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)
