Skip to content

full-text-catalog-properties-general-page.md

Latest commit

 

History

History
90 lines (61 loc) · 3.14 KB

full-text-catalog-properties-general-page.md

File metadata and controls

90 lines (61 loc) · 3.14 KB
title Full-Text Catalog Properties (General Page) | Microsoft Docs
ms.custom
ms.date 03/08/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology search
ms.topic conceptual
f1_keywords
sql12.swb.fulltextsearch.ftcatalogproperties.general.f1
ms.assetid d1f66762-2d40-4f24-b635-a417d22ee79a
author craigg-msft
ms.author craigg
manager craigg

Full-Text Catalog Properties (General Page)

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

Note

For [!INCLUDEssCurrent] 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.

Options

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 Diacritic in the Merriam-Webster dictionary.

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

Populate Full-Text Indexes