Using Indexes with Overflow Regions

You can use indexes for querying on overflow regions with these caveats:

Examples:

The following example index creation calls DO NOT work for overflow regions.
// This index will not work on an overflow region because there are two iterators in the FROM clause.
createIndex("secIdIndex", "b.secId","/portfolios pf, pf.positions.values b");
// This index will not work on an overflow region because the FROM clause specifies the entrySet
createIndex("indx1", "entries.value.getID", "/exampleRegion.entrySet() entries");
The following example indexes will work for overflow regions.
createIndex("pkidIndex", "p.pkid", "/Portfolios p");
createIndex("indx1", "ks.toString", "/portfolio.keys() ks");