I am having a database table
DuplicatesRemoved with possibly large number of records. I execute certain operations to remove duplicates of users in my application, and every time I remove the duplicates, I keep a track of the duplicate
UserID's by storing them in this table
This table contains a bit field
HistoryRecord. I need to update this field at the end of every "RemoveDuplicates" operation.
I do NOT have any indexes on
I am wondering which of these would be better?
UPDATE DuplicatesRemoved SET HistoryRecord=1 WHERE HistoryRecord<>1
UPDATE DuplicatesRemoved SET HistoryRecord=1
Will Query #1 take less time than Query #2?
I have referred this question but still am not sure about which one would be better for me.