1 out of 4 rated this helpful - Rate this topic

Full-Text Catalog Properties (General Page)

SQL Server 2005

This section shows the options and their functions available on the General page of the Full-Text Catalog Properties dialog box.

Default Catalog: Displays whether the catalog is the default catalog for the database.

Population Status

Indicates the status of the catalog. Possible values are:

Accent Sensitive

View or modify whether the catalog is sensitive to diacritics. Valid values are:

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions