Re: Problem with Ranking

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



<estelle@xxxxxxxxxx> wrote in message
news:1160556142.838404.7350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Information message : MS Search stop limit reached. The full-text query may have returned fe
    ... are being returned in your query. ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: TimeOut again
    ... If you are using join filters, its probably the query. ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Need Help!!! The same query return different result in Full Text Index
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... for some query the sql server will return different number of result at ...
    (microsoft.public.sqlserver.fulltext)
  • Re: help with containstable
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... dynamically create the query, so someone my type in "Bob&Roy Video" ...
    (microsoft.public.sqlserver.fulltext)
  • Re: fulltext on normalized database
    ... Try to restrict the amount of joins you do as much as possible. ... full-text query itself will return all matches to be then trimmed in later ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.datamining)