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.
Mark
[1]:
https://firebirdsql.org/file/documentation/html/en/refdocs/fblangref25/firebird-25-language-reference.html#fblangref25-commons-predcontaining
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel