+ Start a Discussion
sonia singh 14sonia singh 14 

Non Selective query

System.QueryException: 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)
Any solution for this error kindly provide I am querying on Account for populating self lookup with the help of trigger it has more 4 lac records .