If I have a string property that has content similar to a paragraph (usually several sentences of content) and want to speed up search for that property when I do “contains” queries, will making that property an Index help speed that up? Or does indexing only help if you are searching an exact match for the string content?
In other words, I have a property that has string content that i am looking to find partial matches with for example “contains” the phrase “project management”. Does indexing still help make queries like this faster or does it need to be searching for “exact” matches of the entire string for indexing to help?
Is there any documentation that explains how the indexing works behind the scenes? Thanks!