Question 660
A customer searches SQL descriptions for inflected terms but a simple LIKE predicate is slow and misses language variations. The team proposes this approach: Configure a supported full-text index with the right language and test CONTAINS/FREETEXT. Which technical principle supports this approach?
Explanation
Correct Answer
Full-text indexing supports tokenization and linguistic forms beyond basic wildcard searches. Full-text behavior differs from arbitrary substring matching.
Incorrect Answers
LIKE substring matching is not full-text tokenization; full-text indexes provide supported linguistic forms and specialized search.
Stoplists can omit terms from the full-text index. Relevance tests must account for configured word breakers and stopwords.
Full-text token matching differs from arbitrary substring matching. Select suitable full-text syntax and separate other search needs.