[
https://issues.apache.org/jira/browse/OAK-6747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16187437#comment-16187437
]
Julian Reschke edited comment on OAK-6747 at 10/11/17 2:49 PM:
---------------------------------------------------------------
I spent some time with Oracle's "EXPLAIN PLAN FOR", and it seems we can indeed
reduce the number or rows the query considers. How much this actually helps is
not clear yet.
was (Author: reschke):
I spent some time with Oracle's "EXPLAIN PLAN FOR", and it seems we can indeed
re-duce the number or rows the query considers. How much this actually helps is
not clear yet.
> improve index handling in RDBVersionGCSupport
> ---------------------------------------------
>
> Key: OAK-6747
> URL: https://issues.apache.org/jira/browse/OAK-6747
> Project: Jackrabbit Oak
> Issue Type: Improvement
> Components: rdbmk
> Reporter: Julian Reschke
> Assignee: Julian Reschke
> Attachments: OAK-6747.diff
>
>
> We currently find split documents by using "LIKE" to exclude regular
> documents. However, these "LIKE" expressions start with a wildcard, which
> defeats use of the index.
> We may be able to improve this by adding to the already existing exclusion
> patterns, such as:
> {noformat}
> 0:/% 1:/% 2:/% 3:/% 4:/% ...
> {noformat}
> We should benchmark this first, though. See OAK-6719.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
