leavelllusion
Reputation: 329
Should I add WHERE when setting values to constant?
Will the next command work faster if I uncomment the third line?
UPDATE "Users"
SET "Type"=0
-- WHERE "Type"<>0
Upvotes: 0
Views: 49
Answers (1)
Laurenz Albe
Reputation: 247205
The command will be faster (at least not slower) for the following reasons:
It has to modify fewer rows.
It has to add fewer index entries.
Any
ON UPDATEtrigger will fire fewer times.
Upvotes: 1
Related Questions
- WHERE clause is slower with value from CTE than with constant?
- Postgresql Select Constant
- Would the query optimizer be able to extract an effective constant from a WHERE clause to avoid repeated evaluation?
- Selecting and comparing columns which contain constants
- Postgres is it necessary to include two predicates in this where clause?
- Should I use WHERE to evaluate a field that I am going to set anyway?
- Database Wide Constant
- Declaring a constant to be used in the query
- Best practice for constant value in the WHERE clause?
- Create a constant in Postgresql