See Also
You are here: Full-Text Indexing > Truncate full-text index
ContentsIndexHome
PreviousUpNext
Truncate full-text index
Truncate full-text index

 

Full-text index content truncate syntax is identical to the table’s truncation command. 

Syntax:  

TRUNCATE TABLE fulltext_index_name

 

The Lucene full-text index will be re-created and all indexed data lost. From this point, the current DB table’s content will not be found in a full-text search. However, new changes will appear in full-text index. The full-text truncation technique could be applied for performance gain to minimize the size of the index. For example, we truncate old data, which stays in the DB table as so-called archived objects, but is not indexed. Only new/fresh changes are indexed.