Table of Contents

Property FullTextSearchClobs

Namespace
YndigoBlue.Velocity.Data.Teradata
Assembly
YndigoBlue.Velocity.dll

FullTextSearchClobs

Gets or sets whether full-text search indexes support CLOB (Character Large Object) columns.

public bool FullTextSearchClobs { get; set; }

Property Value

bool

Remarks

When enabled, full-text indexes include CLOB columns, allowing text search across large text fields (up to 2GB). When disabled, CLOBs are truncated at VarCharCastSize characters (default 32,000) before indexing.

Performance Trade-off:

  • Enabled (True): Supports full-length CLOBs in indexes but significantly slower index creation and maintenance. Use only if you need to search the complete content of very large text fields.
  • Disabled (False - Default): CLOBs are cast to 32,000-character VARCHAR before indexing. Much faster index creation, but you can only search the first 32,000 characters of CLOB data. Suitable for most applications since most text search happens on the beginning of documents.

This setting only applies when FullTextSearchEnabled is true.