[
https://issues.apache.org/jira/browse/OAK-1150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13816007#comment-13816007
]
Thomas Mueller commented on OAK-1150:
-------------------------------------
Also interesting, the number of nodes per index (the total number of nodes in
the repository, including nodes in the index, is about 600000):
{code}
337027 /oak:index/nodetype
51161 /oak:index/slingResourceType
15365 /oak:index/uuid
8701 /oak:index/type
4544 /oak:index/lucene
{code}
Using the following query:
{code}
select (select count(*) from test t2 where t2.path
between t1.path || '/' and t1.path || '0') count, t1.path
from test t1 where t1.depth = 2
and t1.path like '/oak:index/%' order by 1 desc
{code}
> NodeType index: don't index all primary and mixin types
> -------------------------------------------------------
>
> Key: OAK-1150
> URL: https://issues.apache.org/jira/browse/OAK-1150
> Project: Jackrabbit Oak
> Issue Type: Improvement
> Reporter: Thomas Mueller
>
> Currently, the nodetype index indexes all primary types and mixin types
> (including nt:base I think).
> This results in many nodes in this index, which unnecessarily increases the
> repository size, but doesn't really help executing queries (running a query
> to get all nt:base nodes doesn't benefit much from using the nodetype index).
> It should also help reduce writes in updating the index, for example for
> OAK-1099
--
This message was sent by Atlassian JIRA
(v6.1#6144)
