Use an efficient WHERE clause

In queries with a WHERE clause that references a table column, always format the WHERE clause so that the column name appears before (to the left of) the condition.

For example, if you want to select all incidents that are active, the following is the correct way to write the query in order to improve performance:
select * from incidents
where active = 1
This same query using the following format may give invalid results or return an error:
select * from incident
where 1 = active