I have a table t1 (part_id int, gen_code int) part_id is a primary key.
I have a cursor on t1 for part_id , I take part_id
go thro different tables , do calculations and update gen_code for that part_id in t1 . This process is very slow and I see waittype 'LATCH_EX' and 'CXPACKET' all the time in process info .
do I have to declare cursor for update? how does it diff from read_only cursor.