I have a table with ~10,000 records.
There is a "viewed" column which contains either 0 or 1.
At some point in my code I want all rows = 1 for the "viewed" column.
Does it matter if I set all rows to 1 or set all rows to 1 that = 0?
For example, is there a performance issue or something else to consider between the 2:
UPDATE table SET viewed = 1;
UPDATE table SET viewed = 1 WHERE viewed = 0;