Re: Nonclustered index which includes XML column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Bob wrote:
In SQL 2005, you can use the new INCLUDE clause to include columns (including XML columns) with an index.

That's odd, if you try to create the index in the SSMS designer then it will not allow you to add the XML column in the included column list, hence I assumed you could not add an XML column as an included column in the index definition. If you create the index using CREATE NONCLUSTERED INDEX then it works fine.

Thanks.
.