[ https://issues.apache.org/jira/browse/OAK-6129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15992432#comment-15992432 ]
Marcel Reutegger commented on OAK-6129: --------------------------------------- The current RDB data model does not store those two fields in dedicated columns. [~reschke], without those two columns and the index described in this issue, the continuous revision GC will not run efficiently on RDB. What were the reasons you decided against a {{_sdType}} column in the initial design of RDBMK? > Create compound index on _sdType and _sdMaxRevTime > -------------------------------------------------- > > Key: OAK-6129 > URL: https://issues.apache.org/jira/browse/OAK-6129 > Project: Jackrabbit Oak > Issue Type: Improvement > Components: mongomk > Reporter: Marcel Reutegger > Assignee: Marcel Reutegger > Fix For: 1.7.0, 1.8 > > > Replace the current index on {{_sdType}} with a partial index on {{_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)