O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Full-Text Indexing xml Columns

xml columns can be full-text indexed, just like relational columns. The big difference is that for xml columns, the word boundary is not whitespace but element delimiters (<, >). Element text is indexed; attribute values are ignored.

It’s important to use exist() when using a full-text T-SQL function such as CONTAINS to reduce unnecessary scans on the XML columns that don’t contain the text you are looking for.

Note

To generate a full-text index, a unique, non-null, single column index is required. The constraint name PK__SimpleBook__2F2FFC0C shown in the following example represents the automatically generated primary key index name for the primary key of SimpleBook. Your instance of SQL Server will likely generate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required