GET /assets.html/content/dam/images/webimages/p1-ko HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter (query=select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/images/webimages/p1-ko') and [hidden] = 'false' union select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/images/webimages/p1-ko') and [hidden] is null order by [jcr:created] desc /* xpath: /jcr:root/content/dam/images/webimages/p1-ko/*[((@hidden = 'false' or not(@hidden)))] order by @jcr:created descending */, path=/content/dam/images/webimages/p1-ko/*, property=[hidden=[is null]]); consider creating an index or changing the query
If you have more than 1000 items in a bucket, you will get it even if you create an index for the only path.
Reason is that when query is fired, it tries to use an index and get the result from the index but if you have more than 1000 items returned from the query which in fact uses index also, you will get this warning. So this problem is about the result set iteration and its size.
You can not do away from this warning apart from making sure you do not have more than 1000 nodes underneath.