max_clause_count index parameter

You can increase the maximum number of query results by setting the max_clause_count index parameter to a value greater than the default value of 1024.

Basic text queries fail when the maximum number of results is exceeded. If a query results in more than the maximum number of results, you receive the following error:

(BTSB0) - bts clucene error: Too Many Clauses

This error can occur during a wildcard or fuzzy search.

The limit of results controls virtual memory usage. Queries with large result sets can result in slower performance and the allocation of more virtual segments. You can monitor the number of virtual segments with the onstat -g seg command.

Example

The following statement creates a bts index with a maximum number of 4000 query results:

CREATE INDEX bts_idx ON bts_tab(text bts_char_ops)
USING bts (max_clause_count="4000")
IN sbspace1;