I have created one catalog for FTS index, can the same catalog be used by by another table in index.
Sql-server – FTs catalog in SQL Server for multiple FT index
full-text-searchsql server
Related Question
- Sql-server – Sql Server Full Text Search one table for text values in another table
- Sql-server – SQL Server 2005: Full-text search catalog design
- Sql-server – How long takes populating catalog in SQL Server 2008 R2 when update a row
- Sql-server – Troubleshooting vanishing fulltext index in SQL Server 2012
- Sql-server – SQL Server 2012: Full Text Catalog taking up all the disk space
- How SQL Server distributes queries between Database Engine and FTS Engine
Best Answer
Yes, you may add several FTS indexes to a single catalog, but a full text index can only be in a single catalog. Since a full text catalog is a database object, all indexes also have to be in the same database.
If you put all of the full text indexes for a database into a single full text catalog, a catalog reorganization will cover all of the indexes in the catalog. This is usually fine unless your indexes are quite large.
The SQL Server Books Online describe the CREATE FULLTEXT INDEX here: http://technet.microsoft.com/en-us/library/ms187317.aspx
If you desire to reorganize one table at a time, then you would want to use a catalog per table.