but we keep on getting a warning message in the log, and query itself takes a long time to run.
Warning Message:*WARN* [JobHandler: /etc/workflow/instances/server0/2017-09-05/report_17:/content/dam/XYZ] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 71000 nodes with filter Filter(query=SELECT * FROM [nt:unstructured] AS metadatas WHERE ISDESCENDANTNODE(metadatas,'/content/dam/XYZ') and NAME() like '%metadata%', path=/content/dam/XYZ//*, property=[:localname=[(%metadata%..]]); consider creating an index or changing the query
If you are following what was shown in the GEMS session and its not working - could be a bug somewhere - please log a support ticket so Eng can fix it.