I´m receiving the following error: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
Even if a field is indexed a filter might still not be selective when:
1. The filter value includes null (for instance binding with a list that contains null)
2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)Class.OpportunityService.calculaPromedio: line 77, column 1Class.OpportunityTriggerHandler.OnBeforeUpdate: line 62, column 1Trigger.OpportunityTrigger: line 15, column 1

The previous error occurs on the object Opportunity when I do a consult.

Here is the method:



Any help will be appreciated.

I´m receiving the following error: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
Even if a field is indexed a filter might still not be selective when:
1. The filter value includes null (for instance binding with a list that contains null)
2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)Class.OpportunityService.calculaPromedio: line 77, column 1Class.OpportunityTriggerHandler.OnBeforeUpdate: line 62, column 1Trigger.OpportunityTrigger: line 15, column 1

The previous error occurs on the object Opportunity when I do a consult.

Here is the method:



Any help will be appreciated.