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 doent
rank is proportional to the number of times the term occurs in the doent
and inversely proportional to the number of doents in which this term
occurs. Then the score is normalized by the doent length. Generally the
more often "backstreet" occurs in the doent, the shorter the doc, the
better the rank is...
BTW, you best source of FTS answers in the
"Abhijeet Raje" <abhijeet2804hotmail.com> wrote in message
> ranking is determined by a formula that accounts
> for the frequency of the word in the doent/row compared with the
> frequency of the
> word occuring in all doents/rows weighted against the total number of
> 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--> 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 :-(