Force OAK index used

[danchapmanme]

In AEM 6.0 using OAK, is it possible when writing a XPATH query to force what index is being used rather that letting the system determine which it thinks is the fastest evaluated index.

[Jörg_Hoh · Accepted solution]

Hi,

it is not possible. You can use EXPLAIN to check why Oak uses a certain index.

kind regards,
Jörg

[Lokesh_Shivalingaiah]

when it already uses the fastest index, any reason why you would like to override it ??

[kautuk_sahni]

Hi

Could you please share the use-case for the community.

Thanks and Regards

Kautuk Sahni

[danchapmanme]

I am already using the explain tool. I have observed that it doesn't always pick the fastest - when lucene index is 510.0, cq:tag index is 310.0, it still prefers to use the slowest - traverse.

[Lokesh_Shivalingaiah]

It should not be the case. However can you share your query ?

[Opkar_Gill]

Hi,

can you take a screenshot of the output when you run the query with the "Explain Query" page, similar to [1].

Regards,

Opkar

[1] https://adobe-consulting-services.github.io/acs-aem-tools/images/explain-query/results.png