June 18, 2012 at 11:00 am
Hi,
I have a scenario where considering XML column also as a part of an index INCLUDE seems to be improving the query plan.
I am not sure if having XML datatype column as a part of an index include is a good idea?
Any thoughts, ideas, suggestions would be appreciated.
Thanks
June 18, 2012 at 11:13 am
If you include the XML column, you are duplicating the column. The XML data will be stored twice, once in the table, once in the index. If that's a couple kb of XML, that may be fine. If it's large, that may be a major problem.
Additionally, you will no longer be able to rebuild that index online.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy