Simple Update statement is taking too much time
917017Aug 17 2012 — edited Apr 1 2013Hi,
I have following update statement which is taking approx. 1 hour to update 4 lacs records. there is no any where clause in this statement and no any index on the updating column. there are only two indexes except primary key which are on other columns.
update cp_t_exception set module_cd='DEFAULT';
Please suggest me what can be the reason of this slowness?
Regards,
Sachin