4 Replies Latest reply on Jul 17, 2017 7:40 AM by smacdonald2008

    ntBaseLucene index

    Alex_Popov Level 1

      Hi,

       

      We are using search by fileName.

      Example:

       

      SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%\_us'

       

      Explain query display WARNINGThis query has characteristics that may cause performance issues when executed against large repositories.

       

      I've adjusted ntBaseLucene index (Add indexNodeName= true on /oak:index/ntBaseLucene/indexRules/nt:base node.Using Oak Utilities : Index Definition Generator.

       

      After such change:

      + Warning disappear and query is much faster

      - Query stopping return results with escaping

       

      Example:

      SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%\_us'

      Return: No results.

       

      SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%_us'

      Return: /etc/project/test/en_us

       

      Does anyone know what's wrong here?

      We are using AEM6.1 with SP1. OAK version 1.2.11

       

      Thanks,

      Alex