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.