 The WHERE clause is not the only clause where sargability can matter; it can also have an effect on ORDER BY, GROUP BY and HAVING clauses.The SELECT clause, on the other hand, can contain non-sargable expressions without adversely affecting the performance.clauses that are sargable typically have field values on the left of the operator, and scalar values or expressions on the right side of the operator.