November 24, 2008 at 7:27 am
Hi ....we have 1 stored proc which is taking long time to execute. It uses the xml datatype and temporary tables which is the main reason it takes long time to execute. I attached the query plan with this post....It takes 25% of time .....Please suggest me tuning this procedure...
Thank you
November 24, 2008 at 9:32 am
It would be very helpful if you posted the code of the query, as well as the execution plan. Can't really do much with just the execution plan.
- 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
November 24, 2008 at 11:55 am
Thanks for the reply...But, I was trying to copy entire query plan to a file....But I can copy only 1 query plan at a time...Is there anyway that we can copy entire query execution plan to a file??
December 4, 2008 at 11:35 am
Just save each part. That's easy enough.
- 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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply