The Containment (WD) Index Type

The Containment (WD) index allows you to store words from a column string of CHAR, VARCHAR, and LONG VARCHAR data.

Note: In order to create LONG VARCHAR columns, you must be specifically licensed to use the unstructured data analytics functionality. For details on the Unstructured Data Analytics Option, see Unstructured Data Analytics in Sybase IQ.

Recommended Use
Use a WD index for the fastest access to columns that contain a list of keywords (for example, in bibliographic record or Web page).
Advantages and Disadvantages of WD
See the following table for advantages and disadvantages of using a WD index.

Parent topic: Sybase IQ Index Types

Created August 28, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com