XPath or SQL2?



Which is the recommend query language in AEM's current lifecycle: XPath or SQL2?

One HelpX article (with a timestamp of 2018 but that does not appear to have been updated since 6.3) says XPath over SQL2

Oak Queries and Indexing

While a HelpX resource with an earlier timestamp of 2017 says SQL2 over XPath

Describing the JCR model in Adobe Experience Manager | at 2:15

Which is the correct recommendation and why?

Thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)




At the moment there is no clear recommendation. Both are supported and the performance of both is comparable. From a specification point of view XPath is deprecated, but the Oak team made the statement at some occassions that they don't plan to drop XPath support.