Expand my Community achievements bar.

Explain Query Tool is showing Oak Indexes being used as blank

Avatar

Level 2

Hi all,

I am using the Explain Query Tool to understand which tool is being used by AEM to run my query. Though the tool is showing a lot of information, it is not showing the Oak:Index being used. Please see the screenshot below:

Oak_Index_Not_Shown.PNG

I want to know which index is being used  for this query. Any help would be really appreciated.

Thanks.

2 Replies

Avatar

Level 7

It seems like no index has been found for this query and it went for full path traversal. In case an appropriate index is found it will show result like as shown in below screenshot.

Just try creating appropriate oak index as per your query demands.

query.JPG

Avatar

Level 2

I have created the indexes using the online tool Oak Index Generator​ and can see in the logs the count against the indexes for the indexed data. How can I be sure that the correct index has been created or not? And if not, how to make a correct one?

P.S.: I am making ensure definitions nodes as per ACS Commons article to create the OAK indexes.