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 ...
Get Microsoft® SQL Server 2012 Unleashed 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.