Professional Web Applications Themes

Full Text Search: How useful is it? - Microsoft SQL / MS SQL Server

Hi, I'm wondering how useful the Full Text Search feature is. It seems to me that combinations of "LIKE '%searchtext%'" do the job just fine. Are there advantages in using it, other the full text search can be a lot faster than using LIKE? Thanks! TomTom...

  1. #1

    Default Full Text Search: How useful is it?

    Hi,

    I'm wondering how useful the Full Text Search feature is. It seems to me
    that combinations of "LIKE '%searchtext%'" do the job just fine. Are there
    advantages in using it, other the full text search can be a lot faster than
    using LIKE?

    Thanks!
    TomTom


    Tom Guest

  2. #2

    Default Full Text Search: How useful is it?

    Have a look in bol for the facilities available.
    Full text search works on words and is very efficient and
    does a lot more than just search for a word.

    Your like statement will always table scan so won't be
    useful on large amounts of data. And what if you want to
    search several columns.
     
    It seems to me 
    just fine. Are there 
    a lot faster than 
    Nigel Guest

  3. #3

    Default Re: Full Text Search: How useful is it?

    Tom,

    Refer the below snippet from the whitepaper found in:

    INF: SQL Server 2000 Full-Text Search Deployment White Paper
    http://support.microsoft.com/default.aspx?scid=kb;en-us;323739

    Why Why use Full-Text Search?
    With a full-text query, you can perform a linguistic search of character
    data. A linguistic search can operate on words and phrases unlike a LIKE
    predicate, which only works on character patterns. Additionally, a full-text
    query can weigh how well the results that are returned rank in comparison to
    the original search condition. This is not possible with a LIKE predicate,
    because it only returns the results that contain the query term.

    Other differences between character based searches performed by a LIKE
    predicate and linguistic searches performed by full-text are:

    A full-text search can remove noise words from the search
    criteria, hence making the search more effective. This is not possible with
    a LIKE predicate.

    A full-text search permits language specific search. This is not
    possible with a LIKE predicate.

    With a full-text search, the data is up-to-date up to the last
    population unless Change Tracking is turned on with the Update Index in
    Background option turned on. With the LIKE predicate, the data that the
    full-text search returns is always up-to-date. Read the "FULL-TEXT SEARCH
    ARCHITECTURE" section of this white paper for an explanation of the Change
    Tracking and Update Index in Background options.

    A full-text search is more efficient at searching large tables
    (greater than 1 million rows) because it uses a pre-composed index. In
    comparison, a LIKE predicate must search for the string through the whole
    table at query time.


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Tom Tom" <com> wrote in message
    news:phx.gbl... 
    there 
    than 


    Dinesh.T.K Guest

  4. #4

    Default Re: Full Text Search: How useful is it?

    Thank you for the informaiton. I appreciate the excerpt from the white
    paper. I'm now taking a look at it.

    Tomtom

    "Dinesh.T.K" <mail.tkdinesh.com> wrote in message
    news:%phx.gbl... 
    full-text 
    to 
    with 
    > there 
    > than 
    >
    >[/ref]


    Tom Guest

  5. #5

    Default Re: Full Text Search: How useful is it?

    Thanks for additional info!

    "Andrew Cencini [MS]" <microsoft.com> wrote in message
    news:phx.gbl... 
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_fulltextsearch.asp 
    rights. [/ref][/ref]
    character [/ref][/ref]
    LIKE 
    > > full-text [/ref]
    > comparison [/ref]
    > predicate, 
    > > with [/ref][/ref]
    is [/ref][/ref]
    last [/ref][/ref]
    in [/ref][/ref]
    the [/ref]
    > SEARCH [/ref]
    > Change [/ref][/ref]
    tables [/ref]
    > whole [/ref][/ref]
    to [/ref][/ref]
    Are [/ref][/ref]
    faster 
    > >
    > >[/ref]
    >
    >[/ref]


    TomTom Guest

  6. #6

    Default Re: Full Text Search: How useful is it?

    Tom,
    In addition, you can get more specific and current information and advise in
    the newsgroup: microsoft.public.sqlserver.fulltext for any related SQL FTS
    related questions!

    Regards,
    John



    "TomTom" <com> wrote in message
    news:phx.gbl... 
    >[/ref]
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_fulltextsearch.asp 
    > rights. [/ref]
    > character [/ref]
    > LIKE 
    > > comparison 
    > > predicate, [/ref][/ref]
    LIKE [/ref][/ref]
    search [/ref][/ref]
    possible [/ref][/ref]
    search. This [/ref][/ref]
    to the [/ref]
    > in [/ref]
    > the 
    > > SEARCH 
    > > Change [/ref][/ref]
    large [/ref][/ref]
    In 
    > > whole [/ref]
    > to [/ref]
    > Are [/ref]
    > faster 
    > >
    > >[/ref]
    >
    >[/ref]


    John Guest

Similar Threads

  1. sql server full-text search
    By fillae in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: May 12th, 01:27 PM
  2. Full text Boolean search
    By David in forum AIX
    Replies: 2
    Last Post: October 29th, 04:16 PM
  3. full text search
    By Tommy in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 9th, 01:36 PM

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