Searching with text search indexes

After you populate a text search index with data, you can search that index. Db2® Text Search supports searches in SQL, XQuery, and SQL/XML.

You can use the following search functions:
  • The SQL function CONTAINS and the XML function xmlcolumn-contains, to create queries for specific words or phrases
  • The SQL function SCORE, to obtain the relevancy of a found text document

Searches on text search indexes can range from the simple, such as queries for the occurrence of a single word in a title, to the complex, such as queries that use Boolean operators or term boosting. In addition to the operators that allow you to refine the complexity of your search, features such as synonym dictionaries and linguistic support can enhance searches on text search indexes.