Property Index or Lucene Index ?

Forum|Forum|4 years ago
January 13, 2022
1 reply
2661 views

I want to add oak index for my query and I wanted to know which would be a better option to use ? Lucene or property index? We have the property and its value to be queried upon.

Will it have an impact on the performance if I go with property index?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by harish_malineni

The Property Index is useful whenever there is a query with a property constraint that is not full-text, i.e exact match. So if you want to index properties whose values are numbers, timestamp or any other specific data then go with Property Index. On the other hand, Lucene Index is for full text constraints(Title, Description and other custom properties with huge text). Lucene index is async, where the sync happens every 5 seconds and Property Index syncs every 10 seconds (This sync period can be changed in OSGi configurations)

If you have the query handy then you can generate the index definition using a Oak Utility

H

harish_malineniAccepted solution

Level 2

The Property Index is useful whenever there is a query with a property constraint that is not full-text, i.e exact match. So if you want to index properties whose values are numbers, timestamp or any other specific data then go with Property Index. On the other hand, Lucene Index is for full text constraints(Title, Description and other custom properties with huge text). Lucene index is async, where the sync happens every 5 seconds and Property Index syncs every 10 seconds (This sync period can be changed in OSGi configurations)

If you have the query handy then you can generate the index definition using a Oak Utility