Tech Tip: Keyword Indexes vs. SQL
PRODUCT: 4D | VERSION: 11 | PLATFORM: Mac & Win
Published On: September 2, 2010
4D v11 SQL supports a new kind of index called the Keyword Index. This index maintains a list of all "keywords" in a text field. This index is accessed using the "contains keyword" operator, %, for example:
QUERY([Tablex];[Tablex]Fieldx % "4D") |
Unfortuntely this concept does not exist in SQL, so the Keyword Index is not accessible from SQL queries.
See Also:
- Tech Note: Multi-Keyword Search
- Tech Note: Advanced Keyword Search
- Tech Tip: The New "Contains keyword" Operator
- Tech Tip: How to get a list of keywords from a keyword index?
- Tech Tip: Use "=" and "%" operators to specify which index to search.
- Tech Note: Keyword Support in 4D v11 SQL
- Tech Note: Keyword Indexes, Part 1
- Tech Note: Keyword Indexes, Part 2
- Tech Note: Keyword Indexes (Part 3)