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 or VARCHAR. |