July 17, 2008 at 2:01 am
Hi people 🙂
I have a table that contains an XML column with a huge xml string in it.
Problem is a normal 'select * from ' takes about 8mins to process.
I writing a stored procedure that interacts with this table and strips
xml for certain values, needless to say the stored procedure takes forever
to execute (8min)...
what are my options in tuning the table or stored procedure?
i.e table is already indexed, and even using NOLOCK it still take forever and
a day to execute a normal select * from...
July 17, 2008 at 4:06 am
first of all it should not take 8 mins
can u tell on which column you have indexed, how many rows are there, how many tables u are referring and what are the joins u are using. on an average what is size of xml ?
also try to check query execution plan.
Regards,
Sandeep Bhutani
Regards,
Sandeep Bhutani
http://codersdiary.somee.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply