Chapter 17. Full-Text Indexing
After completing this chapter, you will be able to
Create a full-text catalog
Create and populate a full-text index
Query full-text data
Database platforms are designed to store and provide rapid retrieval of very large amounts of data. Efficient storage and retrieval is accomplished due to the structure that is imposed on relational data. Unfortunately, not all data within an organization can be structured into the neat rows and columns of a table. In order to handle unstructured data stored in FILESTREAM, XML, and large character columns, SQL Server has an alternate indexing engine designed to provide flexible search capabilities. This chapter will explain how to build full-text catalogs and indexes, as well as how ...
Get Microsoft® SQL Server® 2008 Step by Step 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.
