Query Issue

[Karthik]

Hi All,

I have a weird query error, when querying the user object. The following query throws me an error.

SELECT IsActive,UserPermissionsKnowledgeUser,ContactId,CreatedById from User WHERE UserPermissionsKnowledgeUser = true and isActive = true.

The error says: 

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).

Seems like this query needs an indexed filter in the where clause just because the User Object is too large. I have an external ID field I can use to filter, but that might impact the number of records returned.  I only have like 20 records, but salesforce looking through all the rows to return 20 records sounds ridiculous.

Any work around or a fix to avoid this? Thanks in advance.

Thanks

Karthik.

[Kalyan Kuchi]

It's been a while I saw this but putting this in batch class might help

Sent from my iPhone

--
You received this message because you are subscribed to the Google Groups "salesforce professionals" group.
To unsubscribe from this group and stop receiving emails from it, send an email to salesforce-profess...@googlegroups.com.
To post to this group, send email to salesforce-p...@googlegroups.com.
Visit this group at http://groups.google.com/group/salesforce-professionals?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Narasimha]

add where id != null to your query.

[RB Chowdary]

Hi Karthik,

When you're querying a Object and that has more than one lack records. Then you need to use Indexed Fields in where clause of Query.

Find the below link, it can help you.

http://www.salesforce.com/us/developer/docs/apexcode/Content/langCon_apex_SOQL_VLSQ.htm

Thanks & Regards.. 

Ravindra Babu Nagaboina

Salesforce.com Certified Force.com Developer

Hyderabad