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 Version 10.1 for Linux, UNIX, and Windows