On 15/02/2021 07:47, Mark Rotteveel wrote: > The Firebird 2.5 Language Reference has the following remark in its > description of CONTAINING[1]: > > """ > When CONTAINING is used in the search conditions of DML queries, the > Firebird optimizer can use an index on the searched column, if a > suitable one exists. > """ > > Is that remark correct? How I understand it, Firebird can't use an > index for this. >
It's incorrect. Firebird could use index with LIKE 'CONSTANT%' (a constant prefix in LIKE - directly spelled in SQL - i.e. not with parameters). Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
