15.02.2021 12: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.
Looks like it was copied from similar description of STARTING WITH few lines
above.
Regards,
Vlad
PS technically, we can use strings from index keys for CONTAINING and other
string
functions - it could be faster than whole table scan. Possible problem here is
that
we have different string representation in index keys.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
