thesaurus not working as expected
277216Jul 20 2004 — edited Jul 20 2004I've created a table (product) with a clob in it (html) and then created an index on the column as :
create index product_idx on product(html)
indextype is ctxsys.context
parameters('section group ctxsys.auto_section_group');
I then created a thesaurus and add relations to the thesaurus. ie. ctxsys.create_relation('THES', 'BW Agent', 'NT', 'Anthrax'); etc.
When I query the table for BW Agent I'm only getting 8 hits. When I query the table for Anthrax I get 500 hits. Should I be getting all the anthrax hits when I query for BW Agent or am I making some false assumptions? If not can anyone tell me what I may have done wrong?
Any help is appreciated.
Rob