SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Full-Text Catalog Properties (General Page)

SQL Server 2012

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

Note Note

For SQL Server 2012 databases, a full-text catalog is a logical concept that refers to a group of full-text indexes. The full-text catalog is a virtual object that does not belong to any filegroup.

Properties

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

  • Crawl in Progress

  • 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 diacritical marks, such as a tilde (~), acute accent mark (´), or umlaut (¨). Valid values are:

  • No

  • Yes

  • For information about diacritical marks, see Diacritical Mark in the MSN Encarta Encyclopedia.

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.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.