KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Use "=" and "%" operators to specify which index to search.
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: June 19, 2008
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

If you have a text field with a keyword index and also a b-tree or cluster b-tree index applied to it, using the “=” operator forces a b-tree or cluster b-tree index search. For example:

Query([Table];[Table]field=”someword”)

This query will fetch all records which contain the string “someword” by searching a b-tree or cluster index, whichever is applied to this field. In contrast, if you use the same query but this time with the “%” operator:

Query([Table];[Table]field%”someword”)

This query will use the keyword index to find the data. For text fields this type of query will be faster than the previous one.