Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT * FROM table_owner.mytable WHERE choral_owner.sample_search(mol, 'CCC', 'SUBSTRUCTURE')=1;

SELECT /*+ DOMAIN_INDEX_SORT() */ * FROM table_owner.mytable WHERE choral_owner.sample_search(mol, 'CCC','SUBSTRUCTURE',1)=1 ORDER BY choral_owner.sample_relevance(1);

Search for a limited number of the most relevant hits

Example

Code Block
languagesql
SELECT * FROM (
	SELECT /*+ DOMAIN_INDEX_SORT() */ * FROM table_owner.mytable WHERE
	choral_owner.sample_search(mol, 'benzene', 'SUBSTRUCTURE',
	1) = 1 ORDER BY choral_owner.sample_relevance(1)
) WHERE rownum <= 10; 

Full fragment search

Full fragment search can be executed by transforming the query structure in a way that it matches only a full fragment of the target structure and by executing a substructure search on this modified query structure. The transformation adds 's*' query search property to all atoms.

...