Update Statement taking too long to execute
I am running an update query on a table that contains approximately 1.5 million rows. Its been 20 minutes now and the query is still running. Its the simplest update statement one could write,
Update TableA Set Column1 = '0'.
This column is indexed. I need to use this statement within a procedure hence the concern. The explain plan looks like this:
UPDATE STATEMENT Optimizer Mode=ALL_ROWS 1 M 43984
UPDATE TABLEA
TABLE ACCESS FULL TABLEQ 1 M 24 M 43984
Any input on how to rectify this would be appreciated. Thanks.