Hi Kalyanar,I checked the explain plan after adding a Property Index and its giving much better performance, many thanks for sharing this.Thanks, Souradeep

I understand when you said to index the property, the thing is in that case I would have to add an additional distinguishable property for each asset which will tell me that its the asset I am looking for. Is there a way I can do it without creating a new property just by utilizing the path.

Thanks for the update, I also have another property for each asset which can tell me its in which path. If I use like predicate, it is working fine. Can you tell me if using an index property will better the performance than using this predicate?

I went through the steps mentioned to create a index, but I don't think it is the solution to my problem.What I am asking is we are looking to find the assets under a given path which has a given property. However there are multiple such paths here with similar pattern, so I would like to put someth...

Thanks for the update. Could you please provide the steps to do that?

Hi,Is there a way I can use regex or something similar to narrow down the number of nodes across which a query will search to find the results.I am currently using like this:SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE(s,'/content/dam/a') and [jcr:content/metadata/sku]='XYZ'However I know m...