Setting Up Full-Text Indexes
Setting up full-text indexes is not a one-step process. With increased flexibility often comes increased complexity. Assuming the Microsoft Search service is started, the process required to set up a specific table column so that it can be searched with full-text search syntax such as the CONTAINS predicate and the FREETEXTTABLE rowset function includes six steps.
1. | Full-text indexing must be enabled in the host database. |
2. | Full-text catalogs must be created for the database. |
3. | Full-text indexing must then be enabled for the host table and associated with a full-text catalog. |
4. | The column is then added to the table's full-text index. |
5. | This full-text index is then activated. |
6. | The full-text catalog must then be ... |
Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
