Do Not #02 Use formula-field in WHERE clause
Nov 15, 2023
Using formula-field in WHERE clause slows down the SOQL query, leads to a TableScan leading operation, increased cost and cardinality, and eventually will result in “non-selective query” issues once the number of records on the object reaches certain threshold.