Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Is There a Quick Way to Get a Total Match Count (estimate ..

  
   Database Forums (Home) -> Full Text RSS
Next:  Varchar type column with null value has a '\' whe..  
Author Message
Wenbin Zhang

External


Since: Aug 13, 2005
Posts: 1



(Msg. 1) Posted: Sat Aug 13, 2005 11:02 am
Post subject: Is There a Quick Way to Get a Total Match Count (estimate is
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
Hi,

I am using the June CTP release of SQL Server 2005 on Windows Sever 2003.

Is there a quick way to get a total natch count (estimate is OK)
of a SQL FullText query? I am working with about 10 million r
ows of simple character data.

The following SQL simply returns too slow due to disk IO on the disk
with the relational table when the number of hits is large (say half
millions)

select count(*) from CONTAINSTABLE(MyTableName, FTColumnName, '
"QueryPhrase" ')

Thanks,
Wenbin Zhang

 >> Stay informed about: Is There a Quick Way to Get a Total Match Count (estimate .. 
Back to top
Login to vote
Baz

External


Since: Apr 21, 2010
Posts: 1



(Msg. 2) Posted: Wed Apr 21, 2010 12:25 am
Post subject: RE: Is There a Quick Way to Get a Total Match Count (estimate is OK) of a SQL FullText Query? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
It's fun answering a 5 year-old post, but just in case: why would it be faster to do more in a stored proc?

From http://www.developmentnow.com/g/104_2005_8_0_0_579691/Is-There-a-Quick...y-to-Ge

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

 >> Stay informed about: Is There a Quick Way to Get a Total Match Count (estimate .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Does SQL2005 still require all FTI keywords to match in th.. - Hello, My understanding of full-text index searching is that CONTAINS() requires that all the keywords supplied (separated by AND) must match in the same column in order for the record to be considered a match and returned. So if we have a situation..

Custom Text Match routine for everybody - All, I implemented a “SmartTextMatch ©” process to match two data sets by their descriptions. This process is very useful in merging data from disparate systems. The process consists of three steps: 1) Pre-processing data – cleansing,..

Grab text near match in fulltext - Is there a way to grab a bit of text near the first word the fulltext search matches? We're currently showing a summary to people, which is written by the user, but obviously does not contain the keyword someone searched for. And people think the search...

Quoted literal strings won't force a phrase match - Hello all, From what I've read, SQL Server is supposed to do a phrase match when you do a full text search that contains quoted literal strings. So, for example, if I did a full text search on the phrase "time out" and I put it in quotes, it'...

Full Text Search Timing Out with only 20 total users - Hi SQL group, I am having a major issue with search and fulltext indexes. Here is the code I am using to add a fulltext to the User table: CREATE FULLTEXT INDEX ON dbo.[User] ( LastName ,FirstName ...
   Database Forums (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]