Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    rsurujbhLinksys
    "Poor performing query" when searching for...
    Topic posted April 12, 2012 by rsurujbhLinksys Red Ribbon: 250+ Points, last edited April 12, 2012 
    607 Views, 1 Comment
    Title:
    "Poor performing query" when searching for Contacts using Email Address
    Content:

    Hello,
    When executing the following ROQL query using QueryCSV, we are getting the following SOAP error: "Poor performing query - too many rows examined".  Understandable, due to the size of our database.

    ROQL:
    SELECT C.ID FROM Contact C WHERE C.Emails.EmailList.AddressType = 0 AND  C.Emails.EmailList.Address LIKE 'user@domain.com'

    It works fine when using the equals (=) operator.  I am using LIKE to account for case insensitivity.
    Any pointers?

    The idea is to search for/return Contact ID using a contact’s primary email address as the only search criteria.

    Thanks!

    Version:
    Feb 2011 SP2

    Comment