Working with Full-Text Search
On this page
Full-text search allows searching for words or phrases in a large body of text through an inverted index.
fuzzy and performed over the text types
Full-text indexes are only supported on columnstore tables.
CREATE TABLE query using the FULLTEXT index type.
Content in columns that are full-text indexed can be searched using the MATCH syntax.
MATCH clause applies to only one table.
New inserts and updates into columnstore tables may go into a hidden rowstore table first before being flushed to a segment file.
Since an index is created for each segment file, the distribution of words within the segment may affect the score of full-text queries, especially when the segments have very few rows and the columns have very few words.
For more information on Columnstore tables, see How the Columnstore Works.
For examples on how to create a table with a
FULLTEXT index and how to search against that table using
MATCH, see MATCH.
Training: Full-Text Index and Search
Last modified: May 18, 2023