|
How do you increase the performance of %LIKE operator? The % placed after he search word can enable the use of index if one is specified in the index column. This performs better than the other two ways of using % - before the search word OR before and after the search word.
LIKE% works the fastest because it uses the index to search on the column provided an index is specified on the column. Using % after LIKE, results in faster results.
|
