Does RANK and weightage goes hand in hand

[Abhijeet Raje]

Hi,
ranking is determined by a formula that accounts
for the frequency of the word in the document/row compared with the
frequency of the
word occuring in all documents/rows weighted against the total number of
unique
non-noise words in your catalog.

Does this means that if I have fulltext enabled on single column (having
Product Name-- 3times + Manufacturer name ---2Times + Category name-- Once)
And I search for "Toshiba Notebook"
Does weightage is maximum on Product name then manufacturer name then
categry Name.????
will I be having records up where Product name is "Toshiba Notebook" ?

Hope to see respone this time :-(

Regards

Abhijeet

[John Kane]

Abhijeet,
While you have a basic definition of RANK correct, the "spamming", i.e.,
multiple words in one row to get a higher rank is incorrect, for example, if
you search for "backstreet", hits for "backstreet",
"backstreet boys" and "backstreet boys albums" are all really hits for
"backstreet" and they are all exact match for "backstreet". The document
rank is proportional to the number of times the term occurs in the document
and inversely proportional to the number of documents in which this term
occurs. Then the score is normalized by the document length. Generally the
more often "backstreet" occurs in the document, the shorter the doc, the
better the rank is...


Regards,
John
BTW, you best source of FTS answers in the
microsoft.public.sqlserver.fulltext newsgroup.


"Abhijeet Raje" <abhijeet2804@hotmail.com> wrote in message
news:eOfcqSuQDHA.2432@TK2MSFTNGP10.phx.gbl...

> Hi,
> ranking is determined by a formula that accounts
> for the frequency of the word in the document/row compared with the
> frequency of the
> word occuring in all documents/rows weighted against the total number of
> unique
> non-noise words in your catalog.
>
> Does this means that if I have fulltext enabled on single column (having
> Product Name-- 3times + Manufacturer name ---2Times + Category name--

Once)

> And I search for "Toshiba Notebook"
> Does weightage is maximum on Product name then manufacturer name then
> categry Name.????
> will I be having records up where Product name is "Toshiba Notebook" ?
>
> Hope to see respone this time :-(
>
> Regards
>
> Abhijeet
>
>