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");

// These indexes will not work on an overflow region (partition or replicate) because the indexed expression contains a Map field
createIndex("FuncIndex", "['key']", "/ErrorParRegion rgn");
createIndex("FuncIndex", "rgn['id']", "/ErrorRepRegion rgn");
The following example indexes will work for overflow regions.
createIndex("pkidIndex", "p.pkid", "/Portfolios p");
createIndex("indx1", "ks.toString", "/portfolio.keys() ks");