 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / September 2004NEAR operator
What is the specific function of NEAR? I'm indexing across 3 text fields and expect hits for 'white NEAR black' and only getting a hit when the two words are in the same field, but not if they are spread across two of the fields. How NEAR does the other word have to be? Nearness is reflected in rank. The closer together two words are the higher the rank everything else being equal. Nearness is calculated on a per column basis, it cannot look across columns. FreeText factors nearness into rank (everything else being equal) and can look across columns. FreeText ignores the near operator however, as it is calcuated in the rank.  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html > What is the specific function of NEAR? > I'm indexing across 3 text fields and expect hits for 'white NEAR black' and > only getting a hit when the two words are in the same field, but not if they > are spread across two of the fields. > > How NEAR does the other word have to be? Very helpful. I had found that using Freetext instead of Contains was getting me more results. Thanks Hilary. > Nearness is reflected in rank. The closer together two words are the higher > the rank everything else being equal. [quoted text clipped - 12 lines] > > > > How NEAR does the other word have to be? Hilary, results do change when I use NEAR between words with Freetexttable. In fact the returned set when I limit it to top 10 is quite different. I think I can read into your statement below and sort of understand why the difference. I need to take more time to look at my results and then check them against the source data. > Nearness is reflected in rank. The closer together two words are the higher > the rank everything else being equal. [quoted text clipped - 12 lines] > > > > How NEAR does the other word have to be? I'm sure they do change because now you are searching on the word near and getting all the stems of the original search term! SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html > Hilary, results do change when I use NEAR between words with Freetexttable. > In fact the returned set when I limit it to top 10 is quite different. I [quoted text clipped - 20 lines] > > > > > > How NEAR does the other word have to be? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.