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);