Hello folks,

First of all thank you for setting up this group.

Second, I have a question regarding indexes and the CONTAINING in a
SELECT. I think I have reade somewhere (not quite sure where or if I
read it correctly), but I want to confirm if using CONTAINING, it
makes use of indexes we create.
I know that like does not use index. But, if we, for example, use like
with '%text', then it gets translated to STARTS WITH 'text', which
uses indexes.

I know that CONTAINING is case insensitive, and I was wondering if we
can use indexes with it. If not, than what is the alternative solution
we can use?

I look forward for some help from you folks.

All the best,

Fidel.