malachi151
Posting Yak Master
152 Posts |
Posted - 10/08/2012 : 15:37:09
|
What are the performance impacts, if any, of adding an XML column to a table, in relation to queries against the non-XML columns?
In other words, if an add an XML column to a table, will it impact queries against the non-XML columns?
I know it has an impact on distributed queries, i.e. if you try to query a table across a Linked Server that has an XML column in it you can't do that, even if you don't include the XML column in the query, etc.
So let's say that I added an XML column, and its mostly NULL, how would this impact performance, how exactly is it stored on the pages, etc?
Thanks
-------------------------------------------------- My blog: http://practicaltsql.net/ Twitter: @RGPSoftware |
|