Adobe Experience Manager: Handle “Query Without Index Detected” Alert
Adobe Experience Manager as a Cloud Service (AEMaaCS) may send an alert email with the subject line Query Without Index Detected. This alert occurs when a query traverses the entire JCR node structure and leads to performance degradation. To resolve the issue, optimize the query or adjust index configuration.
Description description
Environment
Adobe Experience Manager as a Cloud Service (AEMaaCS)
Issue/Symptoms
-
AEM sends an alert email with the subject “Query Without Index Detected.”
-
The query traverses the entire JCR node structure without an index.
-
Performance degradation occurs due to inefficient query execution.
-
Example query:
code language-none select [ jcr:path] , [ jcr:score] , * from [ sling:Mapping] as a where [ sling:internalRedirect] is not null and [ sling:match] is not null and isdescendantnode(a, ‘/etc/map/https’)
Resolution resolution
By analyzing the AEM logs, identify the program that triggered the query. Depending on the purpose of the program and the number of nodes affected, consider one of the following approaches:
- Optimize the query to reduce traversal and improve efficiency.
- Adjust the index configuration to support the query.
- Consider alternative implementations that avoid such queries, such as enumerating child elements under specific nodes.
- Ignore the alert only if the process completes quickly and doesn’t impact performance.