1. How near is near? Measured in characters, words, or whatever?
2. How do you know? Is this documented? Can't find it anywhere.
3. Can it be adjusted? at design time? at runtime?
I have used a program called Sonar which has powerful proximity options that allow the user to specify proximity in terms of words at runtime. Would like to be able to do that but can't find much on "near" in the documentation other than it seems to relative, provides for left and right nearness, and allows for chaining of multiple search terms.
Hi,
1. Near is mesured in words (depends on wordbreaker).
2. Please refer to a previous post in MS newsgroups : http://groups.google.com/group/microsoft.public.sqlserver.fulltext/browse_frm/thread/d2a3d0646ee6e68d/61db754db51cc5af?lnk=st&q=Near+keyword+in+Full+Text+Search+SQL+Server+2005&rnum=1&hl=en#61db754db51cc5af
3. NEAR ranking formulas are "by design"
Jean-Pierre Riehl
|||Hi Jean-Pierre,
Thanks for the very helpful info and link. A follow-up question if you don’t mind.
Since the size of the “Near” proximity parameter seems to be determined by the wordbreaker used by Sql Server's Full Text Search Engine (with a default value of 50 words), can the wordbreaker be altered (with a sql statement or otherwise) to increase or decrease the proximity of “Near” (i.e., make it more or less than 50 words)?
No comments:
Post a Comment