SOQL queries must be selective, particularly for queries inside triggers for the best performance. To avoid long execution times, non-selective SOQL queries may be terminated by the system. Selective SOQL Query Criteria A query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number…