[jira] [Comment Edited] (OAK-6747) improve index handling in RDBVersionGCSupport

["Julian Reschke (JIRA)" <ji...@apache.org>]

    [ 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)