Oracle Text. Number of hits per document.

Hi,

I'm using Oracle 9iR2 and will shortly be replicating this system in Oracle 10G.

I've just started using an Oracle Context index to perform text searches on quite a large dataset.

I was wondering if it is at all possible to find out the actual number of times a certain word was mentioned in a document, as opposed to the score.

I noticed that as part of the Salton Algorithm, Oracle Text needs to know the actual number of times a story mentions the search term. It seems that this information should be available somewhere in some form.

My queries are normally structured and although count(*) may take a long time to run, it still does not give me what I want.

Any ideas?

Many Thanks,

Kevin. Received on Mon Jun 13 2005 - 09:52:20 CDT