Professional Web Applications Themes

CONTAINSTABLE v/s FREETEXT - Microsoft SQL / MS SQL Server

Hi All, I have one table Customers in Northwind database. While performing FreeText search I want to give weightage ON Columns for a searched phrase. CompanyName weight (1) ContactName weight (.7) ContactTitle weight (.5) Address weight (.5) If I Searched for "Christina" phrase then results will be displayed base on weightage as well as rank. i.e. results having "Christina" in CompanyName should be displayed first. If I found "Christina" only in Address then this should be last. Any Ideas??? Regards Abhijeet...

  1. #1

    Default CONTAINSTABLE v/s FREETEXT

    Hi All,
    I have one table Customers in Northwind database.
    While performing FreeText search I want to give weightage ON Columns for
    a searched phrase.
    CompanyName weight (1) ContactName weight
    (.7)
    ContactTitle weight (.5) Address
    weight (.5)
    If I Searched for "Christina" phrase then results will be displayed base
    on weightage as well as rank.
    i.e. results having "Christina" in CompanyName should be displayed
    first. If I found "Christina" only in Address then this should be last.

    Any Ideas???

    Regards

    Abhijeet


    Abhijeet Raje Guest

  2. #2

    Default Re: CONTAINSTABLE v/s FREETEXT

    Abhijeet,
    First of all, all of the tables in Northwind are much too small for proper
    consideration of the understanding of CONTAINS* vs. FREETEXT*, in the same
    manner as you would not use the Northwind database for performance
    benchmarking of production databases. Note, FREETEXT ignores Boolean
    comparisons. You need a statistically significant number of rows (100K+) as
    well as a significant number of non-noise, unique words for your testing to
    give valid results.

    Also, since you're trying to "weightage ON Columns", you should review KB
    articles: 286787 (Q286787) FIX: Incorrect Results From Full-Text Search on
    Several Columns
    [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;286787[/url] and 294809
    (Q294809) FIX: Full-Text Search Queries with CONTAINS Clause Search Across
    Columns [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;294809[/url]. This
    is the default behavior for SQL Server 2000 as well.

    Regards,
    John
    PS: for the fastest (and best) responses, you should post these specific FTS
    related questions to the newsgroup: microsoft.public.sqlserver.fulltext
    only.


    "Abhijeet Raje" <abhijeet2804hotmail.com> wrote in message
    news:%23HO5DZsQDHA.1988TK2MSFTNGP12.phx.gbl...
    > Hi All,
    > I have one table Customers in Northwind database.
    > While performing FreeText search I want to give weightage ON Columns
    for
    > a searched phrase.
    > CompanyName weight (1) ContactName
    weight
    > (.7)
    > ContactTitle weight (.5) Address
    > weight (.5)
    > If I Searched for "Christina" phrase then results will be displayed
    base
    > on weightage as well as rank.
    > i.e. results having "Christina" in CompanyName should be displayed
    > first. If I found "Christina" only in Address then this should be last.
    >
    > Any Ideas???
    >
    > Regards
    >
    > Abhijeet
    >
    >

    John Kane Guest

Similar Threads

  1. set the default text properties for future freetext annots
    By Bruce_Hensley@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: January 25th, 02:14 AM
  2. FreeText annotation property not recognized?
    By Eric_Abbott@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: January 18th, 10:51 PM
  3. Replies: 0
    Last Post: December 2nd, 11:18 AM
  4. Replies: 4
    Last Post: September 17th, 08:59 PM
  5. FreeText search in DB2 V8.0 for MS Word
    By Uday in forum IBM DB2
    Replies: 1
    Last Post: August 7th, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139