[jira] [Comment Edited] (OAK-1871) Support multi-column property indexes

["Himanshu Sawhney (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14018722#comment-14018722 ] 

Himanshu Sawhney edited comment on OAK-1871 at 6/5/14 12:21 PM:
----------------------------------------------------------------

We have a use case where we would like to search all the nodes which are of particulart "type" and with particular "tag" assigned to them.
and also there is a case where, we search all the nodes which are of particular "type" and created after particular "date". This "created date" property is written on the node itself.


was (Author: hsawhney):
We also have a use case where we would like to search all the nodes which are of particulart "type" and with "tag" assigned to them.
or we search all the nodes which are of particular "type" and created after particular "date". This "created date" property is written on the node itself.

> Support multi-column property indexes
> -------------------------------------
>
>                 Key: OAK-1871
>                 URL: https://issues.apache.org/jira/browse/OAK-1871
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: query
>            Reporter: Thomas Mueller
>
> Currently, all property indexes are single-column. To speed up some use cases, the property index should support multiple columns. Example use case: 
> Property "size" with low cardinality (low number of distinct values, for example "S", "M", "L", "XL"). Property "color" with low number of cardinality ("white", "black", "red",...). The query condition is "where size = 'L' and color = 'white'". The number of matching nodes is small.



--
This message was sent by Atlassian JIRA
(v6.2#6252)