How to get record count only from FTS



Hi,

Is there a way to get the FTS system to return you the count of matches
only, without passing back all the key ids.

Basically if a user doesn't find what they are looking for with their
initial multi term search, i.e '10k resistor tomatoes'.

I want to display a list of the counts for each word. 10k = 500,
resistor = 46000, tomatoes = 5. This will help them refine their
search.

select count(*) from freetexttable([MyCatName],*,'resistor') seems
quite slow where there are a large number of matches as I assume it's
passing the data back for SQL to count. Is there a way to just get the
count it came up with.

Thanks,

.