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

Creating index on a big text column in postgres

Updated January 08, 2019 22: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