IBM® Informix® 12.10

field_token_max index parameter

If you have large documents, you can increase the maximum number of tokens that are indexed by setting the field_token_max index parameter to a positive integer up to 2 000 000 000. By default, 10 000 tokens are indexed in a document. If the average word has 5 characters, approximately 50-60 KB of the document is indexed.

Example

For example, the following statement creates a bts index that creates up to 500 000 tokens per document:

CREATE INDEX books_bts ON books(book_data bts_lvarchar_ops) 
USING bts(field_token_max="500000") IN bts_sbspace;


Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.