Kbase P68611: Understanding the CONTAINS Operator and Word Indexes.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/8/2004 |
|
Status: Unverified
GOAL:
Understanding the CONTAINS Operator and Word Indexes.
FIX:
To process queries containing the CONTAINS operator, Progress uses word indexes.
For Progress to process a query that uses the CONTAINS operator, the field mentioned in the WHERE option must participate in a word index. For example, to process the following query:
FOR EACH item WHERE cat-description CONTAINS "hockey":
DISPLAY item.
END.
Progress looks for the word indexes associated with the item record and its cat-description field. If no such word indexes are found, Progress reports a run-time error. Otherwise, Progress uses the word indexes to retrieve the item records whose cat-description field contains the string "hockey."
Word Index can only have one field component.