We have migrated a website from cq 5.4 to AEM 6.0. After migrating our mails(registration mails used by user) are getting delayed. The error being thrown is
WARN* Traversed 1000 nodes with filter Filter(query=select ...) consider creating an index or changing the query
Got this from the documentation:
Unlike Jackrabbit 2, Oak does not index content by default. Custom indexes need to be created when necessary, much like with traditional relational databases. If there is no index for a specific query then the whole repository will be traversed. The query will still work but probably be very slow.
How to create an index such that it will only traverse to check whether the record of the user already exists and not traverse the whole repository.
Thanks upfront for the help.
Update: SELECT * FROM nt:unstructured WHERE jcr:path LIKE '/home/users/%%/profile' AND email='%s'