See the following table for advantages and disadvantages of using a WD index.
Advantages |
Disadvantages |
|---|---|
Huge performance gains are possible for large loads. Certain LIKE predicates execute faster with this index. CONTAINS predicate used with this index takes precedence over the LIKE predicate. Best way to index keywords or parts of a URL. |
Disk space requirements may potentially be very large. Index not possible if uniqueness enforced. Can only use this index if data in your columns is CHAR, VARCHAR, or LONG VARCHAR. |
For information on load performance improvements for WD indexes, see “Improved loading for large single (fact) tables” in Chapter 4, “Managing System Resources” of the Performance and Tuning Guide.
