Near keyword in Full Text Search SQL Server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BrunoX - 15 Aug 2007 20:50 GMT

I have a SQL Server 2005 with SP2 and when use the FTS, a could observe that
AND and NEAR opertors are returning exactly the same results.

Anyone has any ideas?

Tanks in advanced

Reply to this Message

Hilary Cotter - 16 Aug 2007 01:46 GMT

With FreeText they do. With contains if they are near to each other they
will as well, with containstable the rank will drop off after a separation
distance of 50 words, results with a separation distance in excess of 50
words will not show up. With freetexttable after 50 words the rank will be 0
but they will show up until 1326 (IIRC) words separation - this is by
design.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I have a SQL Server 2005 with SP2 and when use the FTS, a could observe
>that
[quoted text clipped - 3 lines]
>
> Tanks in advanced

Reply to this Message

BrunoX - 17 Aug 2007 02:21 GMT

Tanks Hilary,
Now I am using CONTAINSTABLE and analyzing the proximity by the value of rank.

> With FreeText they do. With contains if they are near to each other they
> will as well, with containstable the rank will drop off after a separation
[quoted text clipped - 9 lines]
> >
> > Tanks in advanced

Reply to this Message