Typed XML type vs Untyped XML type in SQL Server

By Santhosh N

This explains difference between typed and untyped XML Type in Sql Server.

1) Typed XML type have XML schemas to validate the Data where as Untyped XML type does not have schema.
2) Typed XML type has advantage of storage and query optimizations where as Untyped XML type does not have this advantage.
3) Typed XML types can be validated at both client side and Server side where as Untyped XML types does not have option to validate on server side as they do not have any schemas.
4) Typed XML types can take advantage of type information during compilations of queries.

Related FAQs

This explains how to create secondary XML indexes and different types of Secondary indexes that can be created for XML Data types in SQL Server
This explains about the limitations of the XML Data type in Sql Server in terms of creating Index
You could check if the index created on the table is being used or not by monitoring that and queried
This explains the difference between the Clustered Index and Non Clustered Index.
Typed XML type vs Untyped XML type in SQL Server  (1387 Views)