Full text search

Hello,
Can anybody explain me why is it showing rank as 0 always in the result?
Table Data:
LLBPSEPG
This is test for the Search
search test for heat
mango apple banana
eating banana is good for health
man eats rice healthy
big laod in the ship hot
SPEG App LLBP - Next LLBP
Lesson learned are from mistakes
good apples are tasty dry
mangos are too costly dried
it is time for starting the project
Query:
SELECT LLBPSEPG
FROM T_TM_LLBPData a, FREETEXTTABLE(T_TM_LLBPData, LLBPSEPG, 'apple banana
mango ') b
WHERE a.LLBPNo = b.[key]
Output:
LLBPSEPG Rank
mangos are too costly dried 0
eating banana is good for health 0
mango apple banana 0
good apples are tasty dry 0
thanks and regards
SathianSathian,
Is the text below "Table data" and for column "LLBPSEPG" the actual text and
number of rows (1) in your table "T_TM_LLBPData"? If so, then this is too
small a table to get correct RANK values. Specifically, RANK requires a
statistically significant number of rows (usually >10,000) and a
corresponding number of unique non-noise words to get correct RANK values
returned. See SQL Server 2000 BOL title "Full-text Search Recommendations"
for more information on RANK. Additionally, your FREETEXTTABLE query is
searching for the phrase "apple banana mango" and while no one row has this
exact phrase, you did get results for variations of these words including
"apples" for your query specifying "apple". You might want to try searching
on the phrase "mango apple banana" as there is an exact match for this
phrase in your small table's data.
Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sathian T" <sathian.t@.in.Bosch.com> wrote in message
news:cufqjk$g8h$1@.ns2.fe.internet.bosch.com...
> Hello,
> Can anybody explain me why is it showing rank as 0 always in the result?
>
> Table Data:
> LLBPSEPG
> This is test for the Search
> search test for heat
> mango apple banana
> eating banana is good for health
> man eats rice healthy
> big laod in the ship hot
> SPEG App LLBP - Next LLBP
> Lesson learned are from mistakes
> good apples are tasty dry
> mangos are too costly dried
> it is time for starting the project
>
> Query:
> SELECT LLBPSEPG
> FROM T_TM_LLBPData a, FREETEXTTABLE(T_TM_LLBPData, LLBPSEPG, 'apple banana
> mango ') b
> WHERE a.LLBPNo = b.[key]
> Output:
> LLBPSEPG Rank
> mangos are too costly dried 0
> eating banana is good for health 0
> mango apple banana 0
> good apples are tasty dry 0
>
> thanks and regards
> Sathian
>
>|||Dear Friends,
Do any of you have an answer for this?
Regards
Sathian|||Sathian,
Is the text below "Table data" and for column "LLBPSEPG" the actual text and
number of rows (1) in your table "T_TM_LLBPData"? If so, then this is too
small a table to get correct RANK values. Specifically, RANK requires a
statistically significant number of rows (usually >10,000) and a
corresponding number of unique non-noise words to get correct RANK values
returned. See SQL Server 2000 BOL title "Full-text Search Recommendations"
for more information on RANK. Additionally, your FREETEXTTABLE query is
searching for the phrase "apple banana mango" and while no one row has this
exact phrase, you did get results for variations of these words including
"apples" for your query specifying "apple". You might want to try searching
on the phrase "mango apple banana" as there is an exact match for this
phrase in your small table's data.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sathian T" <sathian.t@.in.Bosch.com> wrote in message
news:cv18fk$bqn$1@.ns2.fe.internet.bosch.com...
> Dear Friends,
> Do any of you have an answer for this?
> Regards
> Sathian
>
>