To enhance performance during search, consider the following issues:
When searching within SQL:
If you notice a decrease in performance, Use the explain
statement to check the processing plan of the DB2 Optimizer.
Parametric search can make searching faster, especially if you use
other search predicates to reduce the result size.
Use the result limit keyword if you do not require all of the
results.
When searching with the stored procedure:
As the specified cache table expression is copied from the database into
memory, ensure that your workstation has enough memory available for this
data. If there is insufficient memory, paging space is used, which
decreases search performance.
Note
For the latest performance tips, go to the DB2 Net Search Extender Web
site:
www.ibm.com/software/data/db2/extenders/netsearch/index.html