This message was deleted.

generally they're slower

In the few random experiments I performed on our Druid setup, however, ICONTAINS_STRING performed about 4-5 times better for a result set that's was limited to 100k records with the

LIMIT

clause.

wow, good to know. i better update my information 🙂