Full-Text Index Incremental Population in Sql Server

If you want to perform an incremental population of a full-text index in Sql Server, you must have a column with the data type of timestamp in each table that you want to index.  If you do not have a column of type timestamp, the incremental population will turn into a full population, which is much more resource intensive.

Wally

1 Comment

  • This is also true in SQL Server 7.0 and SQL Server 2000, it just wasn't documented. Although, an Incremental Population is no more intensive as a Full Population and in 7.0 & 2000 the latter can take as long to complete as the former, even with no change.



    John

Comments have been disabled for this content.