NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
In this case, it seemed safe to make the according changes, because it is not very likely that another status will be added to the system (and thus the two where clauses are and will stay equivalent). However, this cannot be generalised to other cases.
{{Note|This does not mean that it is generally better to have ''negative'' WHERE clauses instead of ''positive'' ones! It is just an example encountered in a specific context, with a specific database and data volume and content. Therefore, all the previous examples are just illustrative and aim at giving ideas on how to optimize a query.}}
== Summary of recommendations ==__NOEDITSECTION__