Optimize wildcard searching in a nVARCHAR(MAX) field

by Krishn   Last Updated April 20, 2018 09:06 AM

I have been asked to improve the searching capabilities of a LIKE '%SOMETEXT%' predicate on an NVARCHAR(MAX) field. I am aware of full text indexes but am not sure if they are the best strategy. A traditional rowstore index obviously wouldn't do the job given that NVARCHAR(MAX) isn't an acceptable index key value and also I'd be searching using (LIKE '%SOME TEXT%') so I wouldn't be able to write a sargable statement.

Is a full text index the best option for this?

Related Questions

Create and use Fulltext Index in a Stored Procedure

Updated March 15, 2017 21:06 PM

How to repair all indexes in a MySQL database?

Updated April 25, 2015 21:02 PM

List full text indexes in Oracle database

Updated June 19, 2015 23:02 PM

Fulltext match() against() returning empty set

Updated March 02, 2018 17:06 PM

Cache file /home/queryxchang/public_html/apps/frontend/config/../cache/-q-7-204502-optimize-wildcard-searching-in-a-nvarchar-max-field- could not be written