Problem with Ranking

[e***@xagoon.com]

Hi All,

I have a problem with the ranking in my query.. maybe i didn't
understand well how it works.
Here is my questions :
I have 4 items : I added the string "159357" to each one:
00006 in Title
00004 in Resolution Description
00002 in Description
00005 in Resolution Title


I send this query :

SELECT "DAV:href",
"urn:schemas.microsoft.com:fulltextqueryinfo:rank"
FROM (TABLE Solution_Index..SCOPE() UNION ALL TABLE
Non_Portal_Content..SCOPE() )
WHERE WITH
("urn:schemas.microsoft.com:htmlinfo:metainfo:DC.TITLE":0.4,
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.RESOLUTIONDESCRIPTION":0.3
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.SOLUTIONDESCRIPTION":0.2,
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.RESOLUTIONTITLE":0.1,
)AS #WeightedProps
(FREETEXT
(#WeightedProps, '159357')
AND
("urn:schemas.microsoft.com:fulltextqueryinfo:Sourcegroup"
= 'OneCRMSolutionsContent'
))
ORDER BY "urn:schemas.microsoft.com:fulltextqueryinfo:rank" DESC

After Index I send query the search result should be in order: 6 ,4,2,5
And i get the items in this 4,6,2,5....

Do you know why? did i miss something?

Thanks for the help
Estelle

[Hilary Cotter]

Run you force a merge to see if this orders your results correctly? Also are
these the only documents in your catalog? Other documents with the same term
will skew the results.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

Post by e***@xagoon.com
Hi All,
I have a problem with the ranking in my query.. maybe i didn't
understand well how it works.
00006 in Title
00004 in Resolution Description
00002 in Description
00005 in Resolution Title
SELECT "DAV:href",
"urn:schemas.microsoft.com:fulltextqueryinfo:rank"
FROM (TABLE Solution_Index..SCOPE() UNION ALL TABLE
Non_Portal_Content..SCOPE() )
WHERE WITH
("urn:schemas.microsoft.com:htmlinfo:metainfo:DC.TITLE":0.4,
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.RESOLUTIONDESCRIPTION":0.3
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.SOLUTIONDESCRIPTION":0.2,
"urn:schemas.microsoft.com:htmlinfo:metainfo:DC.RESOLUTIONTITLE":0.1,
)AS #WeightedProps
(FREETEXT
(#WeightedProps, '159357')
AND
("urn:schemas.microsoft.com:fulltextqueryinfo:Sourcegroup"
= 'OneCRMSolutionsContent'
))
ORDER BY "urn:schemas.microsoft.com:fulltextqueryinfo:rank" DESC
After Index I send query the search result should be in order: 6 ,4,2,5
And i get the items in this 4,6,2,5....
Do you know why? did i miss something?
Thanks for the help
Estelle