You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Himanshu Sawhney (JIRA)" <ji...@apache.org> on 2014/06/05 14:14:04 UTC

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

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

Himanshu Sawhney commented on OAK-1871:
---------------------------------------

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)