When is the full text in the sql server updated?

Question

I use full-text search in one of my stored procedures. Prior to this (a typical example will take several minutes) I insert elements into a table with a full text index and about 3.5 million rows in a table. The fact is that the item does not exist (or the search query cannot find it) when I try to find it in the top stored procedure. Therefore, I assume that the index is still not updating at this point.

The question is ... Could this be so, or is my problem somewhere else?

If yes ... When is the full-text index updated? Index processing time depends on the amount of data that it has? How long will it take, usually about 4 million records?

I am using SQL Server 2008.

Answer 1

So far, I have learned that full text indexes are “scanned” and that it may actually be that the index has not yet been processed in my situation. We can, for example, check this in sys.fulltext_indexes, as in:

SELECT OBJECT_NAME(object_id), is_enabled, has_crawl_completed, crawl_type, crawl_start_date, crawl_end_date
FROM sys.fulltext_indexes;

* See parameter CHANGE_TRACKINGfor command CREATE FULLTEXT INDEX.