Which is best way to update DB table

Hi Guru's,

I wanted to know which is the best way to update the database table entries from performance point of view?

Using MODIFY is it a performance issue ?

Regards ,

Praveen