Re: Question about Map indexes

2021-02-16 Thread Alberto Gomez
1759476/database-index-not-used-if-the-where-criteria-is [2] https://geode.apache.org/docs/guide/19/developing/query_index/indexing_guidelines.html From: Alberto Gomez Sent: Saturday, February 13, 2021 5:40 PM To: dev@geode.apache.org Subject: Re: Question about

Re: Question about Map indexes

2021-02-13 Thread Alberto Gomez
exception to be able to distinguish both cases. Anyway, could you please check if we are in the right direction? Thanks, Alberto From: Jason Huynh Sent: Thursday, February 11, 2021 10:57 PM To: dev@geode.apache.org Subject: Re: Question about Map indexes Hi

Re: Question about Map indexes

2021-02-11 Thread Jason Huynh
Hi Alberto, I haven't checked the PR yet, just read through the email. The first thought that comes to mind is when someone does a != query. The index still has to supply the correct answer to the query (all entries with null or undefined values possibly) I'll try to think of other cases whe

Question about Map indexes

2021-02-11 Thread Alberto Gomez
Hi, We have observed that creating an index on a Map field causes the creation of an index entry for every entry created in the region containing the Map, no matter if the Map field contained the key used in the index. Nevertheless, we would expect that only entries whose Map field contain the k