[-] LIKE search ‘Search%’ can use an index. LIKE search ‘%Search’ and ‘%Search%’ can not use an index, instead, it will cause a full table scan;
[-] CONTAINS is used to search for a particular word, phrase or prefix of word or phrase.
CONTAINS(Name, 'Mountain'); -- search a word CONTAINS(Name, '"Mountain Road"'); -- search a phrase CONTAINS(Name, 'Mountain*'); -- search a prefix of a word
[-] FREETEXT is used to search the meaning of the keyword rather than the exact word
Advertisement
