June 1, 2010 at 3:33 pm
I have a lock on the update statement.....After carefully examining the execution plan i noticed there is a 93% Cost on Clustered Index Update pk_xyz_abc....Is there anyway to tune this query(I believe there is no way to tune the query because the Update is taking place on the primary key)
Please help me
Regards,
Pradeep
June 1, 2010 at 3:59 pm
June 1, 2010 at 4:08 pm
The table has around 17 million records and i am trying to update 1 row at a time
June 2, 2010 at 6:11 am
PradeepVallabh (6/1/2010)
I have a lock on the update statement.....After carefully examining the execution plan i noticed there is a 93% Cost on Clustered Index Update pk_xyz_abc....Is there anyway to tune this query(I believe there is no way to tune the query because the Update is taking place on the primary key)Please help me
Regards,
Pradeep
post index defintion , Query and exec plan
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 2, 2010 at 7:57 am
In addition to what Bhuvnesh has requested, please post your update logic as well. So one row at a time; are you using a cursor?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply