Db2 Text Search query planning

There are several aspects to consider when planning your text search query.

Db2 Text Search arguments
Wildcard characters and their expansion limit, the case sensitivity of arguments, and argument options are different types of text search arguments that can all affect query performance.
Db2 Text Search multiple predicates
If a query contains multiple predicates, consider the following limitations depending on how the predicates are organized.
Db2 Text Search locale and language
Locale specification can also impact the performance of a text search query.
Db2 Text Search SCORE function
The score of a document is dynamic and calculated independently for each query.
Db2 Text Search RESULTLIMIT function
Multiple instances of RESULTLIMIT within a query require the same search argument to produce predictable results.
Parser configuration for Db2 Text Search
You can configure some of the settings that are used for XML search.
Db2 Text Search XML namespaces
Searching on XML namespaces requires a workaround.

Parent topic: Text search solution planning

Related reference

CONTAINS function
Db2 Text Search argument syntax
SCORE function
Search syntax for XML documents
xmlcolumn-contains function