Re: Would this take long than 10-15 seconds to complete?

[Andy Andy]

Sure. Please find below entire SQL statement.

mysql> explain UPDATE request_comments c SET c.COMMENT_TEXT ='' where c.COMMENT_TEXT is null;
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
| 1 | SIMPLE | c | index | NULL | PRIMARY | 4 | NULL | 3767 | Using where |
+----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+
1 row in set (0.02 sec)