SAP Sybase IQ offers limited support for the WORD (WD) index on LONG
VARCHAR (CLOB)
columns.
- The widest column supported by the
WD index is the
maximum width for a LOB column. (The maximum
length is equal to 4GB multiplied by the database
page size.) The maximum word length supported by
SAP Sybase IQ is 255 bytes.
- All sp_iqcheckdb options for WD indexes over CHAR and VARCHAR columns are also
supported for LONG
VARCHAR (CLOB) columns, including allocation,
check, and verify modes.
- You can use sp_iqrebuildindex to rebuild a WD index over a LONG VARCHAR (CLOB) column.
Chinese text or documents in a binary format require ETL preprocessing
to locate and transform words into a form that can be parsed by
the WD index.