Population status

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action builds and submits an ALTER FULLTEXT INDEX statement with a START {FULL|INCREMENTAL|UPDATE} POPULATION or STOP | PAUSE | RESUME POPULATION argument, letting you start, stop, pause or resume population of the full-text index.

Note: Before using this action, consult Microsoft SQL Server documentation for detailed information on topics such as timestamp column restrictions on the INCREMENTAL option and the interaction of these options with the background update index and auto change tracking features. For more information, see Accessing Third Party Documentation.

Platform Availability

To Control Population of a Full-text Index

  1. Initiate a Population Status action against one or more full-text indexes. For more information, see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the dialog:
Step Settings and tasks

Action Options

Select an option from the Action dropdown: START FULL - every row of the table is retrieved for full-text indexing, even rows that have already been indexed. START INCREMENTAL - only the rows modified since the last population are retrieved. This option only works properly against tables with a timestamp column. START UPDATE - only insertions, updates, or deletions processed since the last change-tracking index update. Change-tracking population must be enabled on the table, but the background update index or the auto change tracking should be disabled. STOP - stops a paused population or population in progress. PAUSE - pauses a FULL population in progress RESUME - resumes a paused FULL population.


Preview the DDL generated for the operation. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.