Managing SQL Server database full-text indexes

When XML documents are stored in an XML column, SQL Server automatically updates the full-text catalog to include text from the new documents. If documents are frequently added and changes are frequently made to existing documents, you should periodically optimize your full-text catalog to maintain optimal performance.

Tip:

Depending on the quantity of text that has been indexed, the optimize operation may take a while to complete. Perform this operation during off-peak hours when fewer people are using the XML column.

Steps:

1. In SQL Server Management Studio's Object Explorer, click the plus sign (+) next to the appropriate SQL Server, then click the plus sign next to Databases.
2. Click the plus sign next to the database, click the plus sign next to Storage, then click the plus sign next to Full-Text Catalogs.
3. Right-click the appropriate full-text catalog and click Properties.
4. Under Catalog action, click Optimize catalog.
5. Click OK.