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

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)

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)