Wednesday, September 25, 2019

System.QueryException: Non-selective query against large object type (more than 200000 rows)

Always try to use WHERE clause to query results, this limits down the number of records getting fetched and thus avoid this error.

Best practice - use indexed fields in WHERE clause.

No comments:

Post a Comment