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 CHAR
, VARCHAR
, TEXT
, and LONGTEXT
.
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.MATCH
clauses.
Note
New inserts and updates into columnstore tables may go into a hidden rowstore table first before being flushed to a segment file.FLUSH
command.
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.
Examples
For examples on how to create a table with a FULLTEXT
index and how to search against that table using MATCH
, see MATCH.
Related Topics
-
Training: Full-Text Index and Search
Last modified: May 18, 2023