Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: Full Text Search vs LIKE Search

    Are there any big differences between the two search techniques? It seems like they are both very similar.

    SELECT * FROM TABLE1 WHERE TEXTFIELD1 LIKE '%DATABASES%'
    SELECT * FROM TABLE1 WHERE CONTAINS (TEXTFIELD1 ,' "DATABASES" ')

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The like query will miss all indexes, but the fulltext query will use some sort of search-page-like index that the FullText engine has created.

    Also, the FullText index has to be manually (or via a job) updated to collect all of the new additions. The like query will simply pick them up.

  3. #3
    Join Date
    Jan 2004
    Posts
    26
    I didn't try full text with mssql but yes... they are very diferent.
    Like may seems to be fast some times, depending on the database, amount of records, etc, etc..
    but compare full text index has the purpose to make very fast searchs. That's why the index it's so big.
    Read about indexes of full text, and you will see that the size it's huge. Like has nothing to do in comparison to full text.

Posting Permissions

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