Need help for Insert/Update

Database

Need help for Insert/Update

Hi,
I am trying to update a column of a table but the query is running forever. Though I am able to fetch records from same table. But when I run Insert/Update query on this table, its running forever. I have run collect stats command also for this table but this was of no help.

COLLECT STATS ON databasename.tablename INDEX(columnname);

Thanks,
Bhaskar
1 REPLY

Re: Need help for Insert/Update

Hi All,
I got the solution. There was a lock on the table. After removal of lock its working fine now.

Thanks,