Example of when using indexed fields can help with search performance?

[the_wolverine]

We have some fields with large unique string values, e.g. EMAIL_SUBJECT, where search performance (particularly on wildcards) is poor. Some of these values may be hundreds of characters in length.

Will indexing this type of field help with search performance?

[the_wolverine · Accepted solution]

In our case, indexing the field provided a significant search performance improvement.