Skip to main content
danchapmanme
Level 3
Nov 3, 2015 1:52 PM UTC
Solved

Force OAK index used

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
joerghoh
joerghohAccepted solution
Adobe Employee
Nov 3, 2015 4:35 PM UTC

Hi,

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

kind regards,
Jörg

View in thread

6 replies

joerghoh
Adobe Employee
joerghohAdobe EmployeeAccepted solution
Adobe Employee
Nov 3, 2015 4:35 PM UTC

Hi,

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

kind regards,
Jörg

Translate
Lokesh_Shivalingaiah
Lokesh_Shivalingaiah
Level 10
Nov 3, 2015 4:45 PM UTC

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

Translate
kautuk_sahni
kautuk_sahni
Level 9
Nov 4, 2015 10:20 AM UTC

Hi

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

 

Thanks and Regards

Kautuk Sahni

Translate
Kautuk Sahni
danchapmanmeAuthor
Level 3
Nov 4, 2015 12:01 PM UTC

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.

Translate
Lokesh_Shivalingaiah
Lokesh_Shivalingaiah
Level 10
Nov 4, 2015 1:04 PM UTC

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

Translate
Adobe Employee
ogillAdobe Employee
Adobe Employee
Nov 4, 2015 6:50 PM UTC

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...