[jira] [Commented] (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 commented on OAK-6747:
-------------------------------------

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)