Text search parameters

You can configure Vertica for text search using the following parameter.

Parameters Description

TextIndexMaxTokenLength

Parameters	Description
TextIndexMaxTokenLength	Controls the maximum size of a token in a text index. For example: `ALTER DATABASE database_name SET PARAMETER TextIndexMaxTokenLength=760;` If the parameter is set to a value greater than 65000 characters, then the tokenizer truncates the token at 65000 characters. Caution Avoid setting this parameter near its maximum value, 65000. Doing so can result in a significant decrease in performance. For optimal performance, set this parameter to the maximum token value of your tokenizer. Default: 128 (characters)

Controls the maximum size of a token in a text index.

For example:

ALTER DATABASE database_name SET PARAMETER TextIndexMaxTokenLength=760;

If the parameter is set to a value greater than 65000 characters, then the tokenizer truncates the token at 65000 characters.

Caution

Avoid setting this parameter near its maximum value, 65000. Doing so can result in a significant decrease in performance. For optimal performance, set this parameter to the maximum token value of your tokenizer.

Default: 128 (characters)