KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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: