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

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:


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:


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.