ChemAxon Forum Archive » Storage & search: JChem Base and JChem Oracle Cartridge

Difference between jcf_containsb and jc_containsb

ChemAxon aa7c50abf8

07-04-2006 08:04:50

Quote:
I’ve installed JChem Cartridge for Oracle and when comparing my installation with another one I noticed that I have the function jcf_containsb while the other system has jc_containsb. Is there any difference between the two?
jc_containsb is an operator available with jc_idxtype indexes, while jcf_containsb is a stored function not relying on the jc_idxtype index. Both of them are included in JChem Cartridge since JChem version 3.0.12. (I do not remember any JChem version where only one of them would have been included.)





The jc_containsb index operator should be used in most cases in order to achieve best search performance. It is only with index operators that the Oracle optimizer will consider highly efficient domain index scans for query plans. Basically, the only reason for jcf_containsb to be there is that index operators are not allowed in PL/SQL assignments.