Strange behavior of wildcard search on big collection

Hi @Roland_I , I recommend taking a look at the explain plan of the query. This can help you understand where the query engine is spending the most time and point to possible optimizations. Feel free to share back the output here.