Post reply

xml indexes

  • May 16, 2008 at 1:15 am

    #154357

    if we use xml indexes on a xml column can it dgrade performance if insert,update and delete is more on that column.

  • May 16, 2008 at 4:55 am

    #816350

    Nope. Its a good practice to have xml indexes on thoes xml colums that stores long complex xml data.

    Basit Ali Farooq
    MCITP Database Administrator
    Microsoft Certified Professional Developer (Web Applications)
    Microsoft Certified Database Administrator
    Microsoft Certified Systems Engineer
    Microsoft Certified Systems Administrator
    CIW Security Analyst
    Cisco Certified Network Associate

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

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