All 7 Full Text Search questions
More in Full Text Search
What is full text search in SQL Server, and how is it different from a regular LIKE search? How do you create a full text index on a table so you can use full text search functions? What is the difference between the CONTAINS and FREETEXT predicates when performing a full text search? How do you perform a proximity search using full text search, finding rows where two words appear near each other? How would you configure full text search to handle different languages correctly, including proper word breaking and stemming? How do you rank and sort full text search results by their relevance to the search query?
Advertisement
Back to results for “Date”
SQL Server › Full Text Search

How often does a full text index need to be updated to reflect changes made to the underlying table's data?

Intermediate

Answer

By default, full text indexes update automatically shortly after the underlying data changes through a background population process, but for very high volume tables you can also configure manual population, giving you control over exactly when the index rebuild happens, such as during a scheduled maintenance window.
ALTER FULLTEXT INDEX ON Articles
SET CHANGE_TRACKING MANUAL;

ALTER FULLTEXT INDEX ON Articles
START UPDATE POPULATION;
Real-world example A high traffic content platform switches its full text index to manual change tracking, scheduling index updates during off peak hours to avoid any performance impact on its busiest traffic periods.

Common follow-ups: What is the tradeoff between automatic and manual full text index updates?;How do you check how up to date a full text index currently is?

SQL Server Agent & Job Scheduling;Query Optimization & Plans
All 7 Full Text Search questions