Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MuffinMan
Posting Yak Master
107 Posts |
 Posted - 2001-09-12 : 12:47:20
|
| We have implemented a web-based search capability that utilizes the Full-Text Querying feature of SQL Server.During testing, we have tried both ContainsTable and FreeTextTable. Per BOL, a Ranking value of between 0 and 1000 is returned. In all the testing we have done, I have NEVER seen a rank greater than 215. Most of the time, I will get lots of results (25-100) but the rank will range from 32 to 4. The records returned DO correspond to the search keywords the user has supplied, but the Ranks seem really low.I was wondering if others have had similiar experiences?Also, which method (ContainsTable or FreeTextTable) CONSISTANLY returns the most relevant data? I have found that ContainsTable is usually a better choice (IF YOU KNOW HOW TO WORD TO SEARCH CORRECTLY!) but that FreeTextTable works better for *novices*.Thoughs? |
|
|
|
|
|
Suggestions to imporve Full Text Querying