SQL Server Performance

which is better full text or individual indexes on table columns...

Discussion in 'T-SQL Performance Tuning for Developers' started by Avnish, Aug 23, 2007.

  1. Avnish New Member

    Hi ,I have table that contains near about 40 fields and search is required on all these 40 fields so for the performace perspective what you guys suggest :a) Seperate indexes on all the fields.b) Full text index on full table.Please this is going to have good amount of data.If you have any other tips or alternatives please suggest those as well
    Avnish, Aug 23, 2007
    #2

  2. ghemant Moderator

    ghemant, Aug 23, 2007
    #3

  3. satya Moderator

    If this is for web based application then going with FTS is better provided the Server resources are pretty good enough to survive onthe pressure when this running.
    http://www.sql-server-performance.com/articles/all/tb_search_optimization_p1.aspx
    http://www.sql-server-performance.com/tips/full_text_search_p1.aspx
    http://msdn2.microsoft.com/en-us/library/aa175787(sql.80).aspx
    http://www.developer.com/db/article.php/3446891
    The above links should give you more information on setup and optimization.
    satya, Aug 23, 2007
    #4

  4. Avnish New Member

    Hi
    I am not able to take decision by reading the articles sent by both of you.
    My Question is what decision you guys would have taken if you faced the same design problem ?
    Avnish, Aug 23, 2007
    #5

  5. satya Moderator

    How often your application connects to the database for this table data?
    What is the hardware configuration?
    What version of SQL you are using?>
    satya, Aug 23, 2007
    #6

  6. Avnish New Member

    Hi
    1) Application frequently connects the table for data for both ( inserting new data and searching for existing data).
    2) hardware info is not known right now.
    3) SQL 2005
    Thanks
    Avnish Kumar
    Avnish, Aug 23, 2007
    #7

  7. satya Moderator

    Go with FULLTEXT search in thsi case based on the improvements within SQL 2005 version, before that ensure to refer the links on configuration too.
    satya, Aug 23, 2007
    #8

  8. Avnish New Member

    Thanks Satya for guidance. I am trying for get Hardware configurations , Once i get it i will share it with you.
    Regards,
    Avnish Kumar
    Avnish, Aug 23, 2007
    #9

Share This Page