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?