|
Home > Archive > Microsoft SQL Server forum > August 2005 > Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7
|
|
| kellygreer1 2005-08-01, 11:23 am |
| Hello group,
Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?
I'm using SQL Server 7 SP3.
Thanks,
Kelly Greer
KellyGreer1@nospam.com
replace nospam with yahoo
| |
| Hilary Cotter 2005-08-01, 1:23 pm |
| Its hardcoded. I believe after 50 words the rank drops off to 0. I also
believe that after 1366 (or some large number of words like that) you will
no longer get a hit.
--
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
"kellygreer1" <kellygreer1@yahoo.com> wrote in message
news:1122912214.203288.58290@g47g2000cwa.googlegroups.com...
> Hello group,
>
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
>
> I'm using SQL Server 7 SP3.
>
> Thanks,
> Kelly Greer
> KellyGreer1@nospam.com
> replace nospam with yahoo
>
| |
| John Kane 2005-08-01, 8:24 pm |
| Kelly,
Q. Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR?
A. Within 50 non-noise words. Additionally, end-of-sentence and
end-of-paragraph also have an effect on the "nearness" of one word or phrase
to another word or phrase.
Q. Is this setting adjustable?
A. No. This is hard-coded.
Q. Is it stored in the registry? INI or config file?
A. No and No. Although, I would hope in some future SQL Server version
(post-SQL Server 2005) that this would be possible, IMHO.
Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"kellygreer1" <kellygreer1@yahoo.com> wrote in message
news:1122912214.203288.58290@g47g2000cwa.googlegroups.com...
> Hello group,
>
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
>
> I'm using SQL Server 7 SP3.
>
> Thanks,
> Kelly Greer
> KellyGreer1@nospam.com
> replace nospam with yahoo
>
|
|
|
|
|