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

Reply via email to