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

[Ameya Agashe]

Hi Gurus,

I was wondering if you could help me understand the below output from Explain, would this update statement be run quicker (10-15 seconds) without causing any deadlocks?

+----+-------------+-------+-------+---------------+---------+---------+------+--------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+---------------+---------+---------+------+--------+-------------+
| 1 | SIMPLE | c | index | NULL | PRIMARY | 4 | NULL | 142253 | Using where |
+----+-------------+-------+-------+---------------+---------+---------+------+--------+-------------+
1 row in set (0.02 sec)


Any guidance would be sincerely appreciated.


Thank you