MySQL Forums
Forum List  »  Quality Assurance

Re: What is better to delete or to update rows in table with indexes?
Posted by: eos li
Date: May 27, 2008 10:04PM

Is the status a primary key?
If it is not a primary key, I think it is good to update the record.
If you delete the record, you have to insert a new record, I think you will spend more time for the operation.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What is better to delete or to update rows in table with indexes?
2058
May 27, 2008 10:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.