September 17, 2008 at 6:38 am
I have an extremely long running query, actually 25 of them, that I inherited. They all access XML documents stored in table columns with XML datatypes.
Their execution plans show that almost 100% of their time is spent on XML Parser objects. Is there anything I can do to speed up XML Parsing or is it "black box" so to speak.
Thanks a lot,
dn
September 17, 2008 at 7:09 am
Have you looked at adding XML indexes to the columns?
I've found that parsing out XML is a major performance hog, but with XML indexes it becomes fast and painless.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply