Post reply

Full Text Index Vs. XML Index

  • July 24, 2008 at 10:58 am

    #210431

    Hi All,

    Please explain me what is the difference between Full Text Index and XML index?

    and when it is necessary...??

    Thanks in advance..

    Milu.:)

  • July 24, 2008 at 1:55 pm

    #848061

    XML indexing in a nutshell is the ability to store XML data in a table then be able to search that XML data to retrieve specific data within the body text. The data is stored in a BLOB so it is normally not good to use if the data is going to be used for alot of modification (to the index).

    There are ways to speed it up but you just need to do some internet research to decide which would be best for you.

    Full Text Indexing is searching against character type data, basically.

  • July 25, 2008 at 10:42 am

    #848580

    Thanks..

    luv's

    Milu..:)

  • July 27, 2008 at 1:02 am

    #848868

    Full Text index can be used to create an index for the data in a column which may be any type (varchar, nvarchar,xml)

    where as XML indexes are used to create an index property on xml data type. It will store the hierarchy of data stored in the xml

    Thanks and Regards,
    Venkatesan Prabu, 😛
    My Blog:

    http://venkattechnicalblog.blogspot.com/

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

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