Hi ,
Although we have indexes (property,lucene ) defined for most of the queries, few of the indexes are going in traversal
For Ex :
On Restart of AEM
*WARN* [Apache Sling Repository Startup Thread] org.apache.jackrabbit.oak.plugins.index.search.spi.query.FulltextIndex$FulltextPathCursor Index-Traversed 140000 nodes with filter Filter(query=SELECT * FROM [nt:base] WHERE ISDESCENDANTNODE([/content]) AND [cq:master] IS NOT NULL, path=/content//*, property=[cq:master=[is not null]])
Therefore it's taking a long time for restart.
OOTB ntBaseLucene
Numdocs count - 5725504 | /oak:index/ntBaseLucene |
Property Field Info - /oak:index/ntBaseLucene cq:master 165543
But logs we see it's going for Index-Traversed although we have index defined.
What is the reason for Index Traversal ? This is happening for lower numdocs indexes also. How do we fix this ?