Full-Text Catalog Properties (General Page)

  • Article

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:

    • Idle
    • CrawlinProgress
    • Paused
    • Throttled
    • Recovering
    • Shutdown
    • Incremental population in progress
    • Building index
    • Disk is full—Paused
    • Change tracking.
  • Item Count
    Displays the number of full-text items in the catalog.
  • Catalog Size
    Displays the size, in megabytes, of the full-text catalog.
  • Name
    The name of the full-text catalog.

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

    • No
    • Yes
  • Filegroup
    Displays the filegroup on which the catalog was created.
  • Last Population Date
    Displays the date the catalog was last populated.
  • Owner
    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.

Catalog Action

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.

See Also

Other Resources

ALTER FULLTEXT CATALOG (Transact-SQL)
Full-Text Indexes
Full-Text Indexing and Querying Process

Help and Information

Getting SQL Server 2005 Assistance