locked
RANK in FREETEXTTABLE and CONTAINSTABLE: RRS feed

  • Question

  • Hi,

    I executed the following queries:

    SELECT * FROM CONTAINSTABLE(DocumentStore_Test,name,'query')

    and

    SELECT * FROM FREETEXTTABLE(DocumentStore_Test,name,'query')

    But I received the different RANK for the above two queries. For the query with CONTAINSTABLE it is '48' and for FREETEXTTABLE it is '102'.

    So my question is for the same table, same column and same search condition, how come RANK can be different? If it should be different, then what is the difference between CONTAINSTABLE and FREETEXTTABLE?

    Thanks,

    Santosh

     

    Friday, January 27, 2012 12:00 PM

All replies

  • It's explained in the same topic.

    Have you ordered the book that I recomended you? That's really a great introduction to full-text, and part of the money goes to WarChild International.

    If you want a full book on Full-Text Michael Coles has one A-Press. That's not a bad book, and he covers more than Robert does. But I think Robert says everything that is essential on those 25 pages.

    And the reason I am terse in my answers about fulltext is that it's only a feature I've read about, but never used for real.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Friday, January 27, 2012 10:54 PM
  • Can anybody help on this please?
    Tuesday, January 31, 2012 3:08 AM