Indexing Columns - SMILES vs Structure

Is is possible to index on more than one column?





I am currently using the evaluation version of JChem Cartridge and I created an index on the cs_structure column. When I tried to use the jc_equals operator on the cd_smiles column it would not work.





However when I dropped the structure index and recreated an index on the cd_smiles column then the search on the smiles string worked OK.





Is it possible to set up the database such that I am able to search over the cd_smiles column and the cd_structure column?





Many thanks.

Please, use the jc_compareb operator with the 't:e' option for cd_structure columns. It is equivalent with jc_equals:

Code:

SQL> select count(*) from jc_nci_10k where jc_compareb(cd_structure, utl_raw.cast_to_raw('Cc1cc(C)c(N)c(C)c1'), 't:e') = 1 SQL> /   COUNT(*) ----------          1 SQL> select count(*) from jc_nci_10k where jc_compare(cd_smiles, 'Cc1cc(C)c(N)c(C)c1', 't:e') = 1;   COUNT(*) ----------          1

Thanks


Peter