TEXT Index

To use TEXT indexes, you must be specifically licensed to use the unstructured data analytics functionality.

Note: See Unstructured Data Analytics.

Unlike a Containment (WD) index, which uses keywords in a column string, a TEXT index stores positional information for terms in the indexed columns. Queries that use TEXT indexes can be faster than those that must scan all the values in the table.

Creating a TEXT Index Using Interactive SQL
Before you can perform a full text search, you must create a TEXT index on the columns you want to search.

Parent topic: Index Types Comparison