Our Log shows this error and we need to add Index to our repository for the same.
I am not sure though what the Index should be fo rofllowing query, Please help:
On Prod Author1 - Occurrence of Errors/Warnings: consider creating an index or changing the query.
Reason : Missing search index that causes large repository traversal causing performance issues due to high disk I/O.
Recommended Actions: Contact customizer to create required search index .
Example from logs :
11.05.2020 12:18:25.885 *WARN* [Thread-95] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter(query=select e.[jcr:path] as [jcr:path], e.[jcr:score] as [jcr:score], e.* from [nt:base] as a inner join [nt:base] as b on ischildnode(b, a) inner join [nt:base] as c on ischildnode(c, b) inner join [nt:base] as d on ischildnode(d, c) inner join [nt:base] as e on ischildnode(e, d) where name(a) = 'wcm' and isdescendantnode(a, '/home') and name(b) = 'notification' and name(c) = 'config' and name(d) = 'subscriptions' and e.[type] = 'page' option(traversal OK) /* xpath: /jcr:root/home//wcm/notification/config/subscriptions/* [@type='page'] option(traversal ok) */, path=/home//*, property=[:localname=[wcm]]); consider creating an index or changing the query
This is still occurring and the accepted solution wasn't the root cause. Can anyone in AEM take a look at this issue? looks like the wcm core aem component is generating the query and can help fixing this issue.