Viewing 2 posts - 1 through 2 (of 2 total)
Go for full text indexing, remember to consider the overheads, please spend some time and read then consider all the facts before implementing.
July 7, 2012 at 9:35 pm
#1510051
Full text indexing is the way to go for your requirement, unless you can change your requirement,I.e. remove the starting %, which I always oppose.
(a.Valuekey LIKE '%string1%' OR
a.ValueKey LIKE...
July 7, 2012 at 9:17 pm
#1510049