[
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:29 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.
We have created an index for "type" property, but ideally we would like to
create following 2 indexes, to fasten the search:
For query 1) Combined index for "type" and "tag"
For query 2) Combined index for "type" and "created date"
was (Author: hsawhney):
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.
> 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)
