How to get record count only from FTS
- From: "Martin" <bigmarts@xxxxxxxxxxx>
- Date: 17 Jan 2007 08:54:26 -0800
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,
.
- Follow-Ups:
- Re: How to get record count only from FTS
- From: Simon Sabin
- Re: How to get record count only from FTS
- From: Hilary Cotter
- Re: How to get record count only from FTS
- Prev by Date: Re: Finding phrases in Word document using SQL2005
- Next by Date: Re: How to get record count only from FTS
- Previous by thread: Finding phrases in Word document using SQL2005
- Next by thread: Re: How to get record count only from FTS
- Index(es):