SQL Server Performance

Fulltext search

Discussion in 'SQL Server 2008 General Developer Questions' started by ismailadar, Feb 4, 2011.

  1. ismailadar New Member

    Hi all
    What is the best situation for using full text search instaed of of searching? I have a table with a varchar(200) coloumn and table has lot of records.when i try to search a word it takes a long time for example when i type select * from tableName where descript like '%tt%' it takes more than 5 seconds.
    I wonder that is it neccesary to use full text search on this table?
    thanx in advance
  2. RamJaddu Member

  3. satya Moderator

Share This Page