How to create a index for a query in AEM6.3 with sp2

Avatar

Avatar

srinivas_chann1

Avatar

srinivas_chann1

srinivas_chann1

08-04-2020

Hi ,

 

We were executing a query with a property is not null in the logs we found that

it is showing it traversed 2000 nodes and suggesting "consider creating an index or changing the query"

 

Could you please suggest as how could i go with creating an index for this 

 

Capture.PNG

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

sunjot16

Employee

Avatar

sunjot16

Employee

sunjot16
Employee

08-04-2020

You can create an index of your query on the Oak Index Definition Generator:

https://oakutils.appspot.com/generate/index

 

Generating custom indexes on queries:

https://helpx.adobe.com/experience-manager/kb/create-custom-oak-index.html

 

 The following documents can help with Oak Queries & Indexing, as well as following the Best Practices to create efficient indexes:

https://helpx.adobe.com/experience-manager/6-3/sites/deploying/using/queries-and-indexing.html

https://helpx.adobe.com/experience-manager/6-3/sites/deploying/using/best-practices-for-queries-and-...

Answers (0)