Advantages and Disadvantages of WD

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 use this index only if data in your columns is CHAR, VARCHAR, or LONG VARCHAR.