[infinispan-issues] [JBoss JIRA] (ISPN-5393) Support mixed indexed and non-indexed fields in DSL based queries

[Adrian Nistor (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adrian Nistor updated ISPN-5393:
--------------------------------
    Description: 
If a query uses both indexed and non-indexed fields we should be able to execute it in two phases. A first less selective query on the index and then post process it by reapplying the whole filter again to results of the first phase.

This should be more efficient than completely ignoring the indexed fields and executing the non-indexed query on the whole data set.

A possible idea to derive the query to be executed in first phase is to apply the Boole-Shannon expansion theorem ([http://en.wikipedia.org/wiki/Boole%27s_expansion_theorem]).

  was:
If a query uses both indexed and non-indexed fields we should be able to execute it in two phases. A fist less selective query on the index and then post process it by reapplying the whole filter again to results of the first phase.

This should be more efficient than completely ignoring the indexed fields and executing the non-indexed query on the whole data set.

A possible idea to derive the query to be executed in first phase is to apply the Boole-Shannon expansion theorem ([http://en.wikipedia.org/wiki/Boole%27s_expansion_theorem]).



> Support mixed indexed and non-indexed fields in DSL based queries
> -----------------------------------------------------------------
>
>                 Key: ISPN-5393
>                 URL: https://issues.jboss.org/browse/ISPN-5393
>             Project: Infinispan
>          Issue Type: Enhancement
>          Components: Embedded Querying
>    Affects Versions: 7.0.0.Final
>            Reporter: Adrian Nistor
>            Assignee: Adrian Nistor
>             Fix For: 8.0.0.Beta1
>
>
> If a query uses both indexed and non-indexed fields we should be able to execute it in two phases. A first less selective query on the index and then post process it by reapplying the whole filter again to results of the first phase.
> This should be more efficient than completely ignoring the indexed fields and executing the non-indexed query on the whole data set.
> A possible idea to derive the query to be executed in first phase is to apply the Boole-Shannon expansion theorem ([http://en.wikipedia.org/wiki/Boole%27s_expansion_theorem]).



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)