Do mysql update queries benefit from an index?

Created Jul 21, 2011 Edited Jul 21, 2011

Viewed 19227

I have a table which I do mainly updates and I'm wondering if update queries would benefit from having an index on the where column and the updated column or an index on just where column?

indexing mysql

Do mysql update queries benefit from an index?

3 Answers