Re: XQuery modify really slow

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

My understanding was that applying the schema to the xml field would
definitely improve performance. I'd suggest you run tests with the
schema applied, and with only a primary xml index on the xml field.
That said, I doubt that it would be as significant of an improvement as
you seem to be looking for. Also, keep in mind the overhead of the
indexes on insert processing if that is how the large xml gets into the
database.

Joe

.