Full-Text Catalog Properties (General Page)
Applies To: SQL Server 2016
This section shows the options and functions available on the General page of the Full-Text Catalog Properties dialog box.
Displays whether the catalog is the default catalog for the database.
Indicates the status of the catalog. Possible values are:
Crawl in Progress
Incremental population in progress
Disk is full—Paused
Displays the number of full-text items in the catalog.
Displays the size, in megabytes, of the full-text catalog.
The name of the full-text catalog.
View or modify whether the catalog is sensitive to diacritical marks, such as a tilde (~), acute accent mark (´), or umlaut (¨). Valid values are:
Last Population Date
Displays the date the catalog was last populated.
The owner of the full-text catalog.
Unique Key Count
The number of unique words that make up the full-text index for the catalog.
|None||Does not perform Optimize catalog, Rebuild catalog, or Repopulate catalog operations.|
|Optimize catalog||Optimizes the space utilization of the catalog and improves query performance. It also improves the accuracy of relevance ranking of search results.|
This action executes ALTER FULLTEXT CATALOG catalog_name REORGANIZE.
|Rebuild catalog||Deletes and rebuilds the full-text catalog. This operation must be performed if a fundamental catalog property is changed, such as accent sensitivity.|
For the rebuild to succeed, the filegroup the full-text catalog resides in must be online or read-writeable. After the rebuild, the full-text index will be repopulated.
This action executes ALTER FULLTEXT CATALOG catalog_name REBUILD.
|Repopulate catalog||Updates the catalog with recent changes to the data. This option does require catalog downtime.|