Contain Clause

Just guessing but... many interesting use cases would require multiple indexes and FIND doesn't support multiple indexes (and never will).
 
Perhaps not even so much multiple indexes, but multiple results. It is not necessarily a predictable common case that the results of a pattern match would only be a single entity. Might be, but how often do you know that in advance?
 
Back
Top