Post reply

What is use of FULL TEXT INDEX ? hOW & WHEN USED?

  • January 2, 2008 at 11:28 pm

    #181724

    Any one please give details about FULL TEXT INDEX, how it is used and when it is used ?

    what is use of FULL TEXT INDEX ?

    please give me explaination with benifit.....

    REGARDS

    PARESH

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • January 3, 2008 at 8:37 am

    #764397

    http://technet.microsoft.com/en-us/library/ms142547.aspx

  • January 4, 2008 at 2:28 am

    #764719

    Full-Text indexex are used for full-text searching. The search which is not possible with ordinary indexes and search procedures can be done using the full-text searching.

    SQL Server full text searching is similar to the searching that you can do with SQL Server books online or online resources such as MSDN or technet. In these search you provide any combination of keywords and it returns a list of hits ranked in order by how closely they match your keyword list.

    The biggest advantage of using full-text search functionality is that each word of your text is indexed, so queries looking for parts of strings can be amazingly fast.

    Basic components of full-text search are –

    a. Full-text indexing - enables the creation and population of the full-text catalogs, which are maintained outside of SQL Server and managed by MS Search Service.

    b. Full text-search uses the new T-SQL predicates (CONTAINS, CONTAINSTABLE, FREETEXT & FREETEXTTABLES) to query these full-text catalogs.

Viewing 3 posts - 1 through 2 (of 2 total)

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