[
https://issues.apache.org/jira/browse/OAK-6165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15996182#comment-15996182
]
Chetan Mehrotra commented on OAK-6165:
--------------------------------------
bq. We can't create indices until these indeed are DB columns, which is a
non-trivial change.
Ack and we should then look into making that change. Probably some other '_xxx'
props in NodeDocument may also require a first class column support in DB row
and we should look into those and determine the final schema.
Then we would need to decide for upgrade i.e. some tooling to migrate existing
tables to newer format
> Create compound index on _sdType and _sdMaxRevTime (RDB)
> --------------------------------------------------------
>
> Key: OAK-6165
> URL: https://issues.apache.org/jira/browse/OAK-6165
> Project: Jackrabbit Oak
> Issue Type: Improvement
> Components: rdbmk
> Reporter: Chetan Mehrotra
> Assignee: Julian Reschke
> Fix For: 1.8
>
>
> Clone for OAK-6129 for RDB i.e. create index on OAK-6129on _sdType and
> _sdMaxRevTime. This is required to run queries issued by the Revision GC
> efficiently.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
