Post reply

Full Text search option

  • June 18, 2008 at 8:35 am

    #122095

    Hi,

    Enabling Full Text search option in 2005 can increase performance of the query if how pls tell as i am doing R & D.

    Waiting for the reply regarding Full Text search option.

    Thanks in advance

    Anjan:)

  • June 18, 2008 at 8:51 am

    #830522

    FullText searching is a different type of querying. I would suggest you start by reading about it in Books Online and on the MS website and come back and post here if you have any specific questions.

  • June 18, 2008 at 8:57 am

    #830530

    Actually we did the query tunning but still that query performance is not gud still getting timeout error.

    I actually wanted to know in which or situation we are using full text search mode can u give some practical examples it will be good for me.

  • June 18, 2008 at 9:25 am

    #830565

    Full Text searching is for searching large values of text for some data, similar to what you get with Google, Live Search, etc.

    If you have queries that you are using to search for exact values, or they are small values (varchar(100 and less) , then you would use normal queries, not full text.

    Full Text is for text. Did you read Books Online?

  • June 18, 2008 at 9:51 am

    #830592

    steve,

    good examples and i have read in Bol also.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply