February 2, 2015 at 4:41 pm
Hey guys,
I'm looking to serialize some NVP data into an XML blob. I plan to put a primary xml index on the column, but my question is, would putting an XSD on the column speed up any queries, or would it just ensure format? I know that with selective xml indices, you can do things like specify the datatype associated with the xpath which can further optimize retrieval.
February 3, 2015 at 5:39 am
I don't have quantifiable measures on this, but yes, I'm pretty sure that having an enforced structure will help to speed the queries. But, they still won't be "fast" because XML queries are pretty memory intensive. Also, be cautious about the syntax used. Wild cards or vague XML paths can seriously negatively impact performance there.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply