Total Pageviews

Sunday, March 22, 2015

Non-selective query against large object type (Issue)


In life many times simple things pose to be more nagging. Thinking of it why would salesforce be any different? In a age of "Lighting" , "Heroku" and "Mobility" there are minor things on the salesforce platform which might test our nerves. One such trifling issue is getting errors of non-selective query against large objects . We keep raking our heads why it keeps coming (as our memory is not always reliable that we had encountered it earlier too).

Error encountered : System.QueryException: Non-selective query against large object type (more than 100000 rows).
Lets ponder on this a bit!

What is a selective Query as against non-selective query?
A query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows below a system-defined threshold. The performance of the SOQL query improves when two or more filters used in the WHERE clause meet the mentioned conditions.
What is Large Object Type?
Object having records in excess of 99999

Solutions
  • Consider an indexed filter
  • Contact salesforce.com about custom indexing.
One will need indexes for all of the fields one is using if SOQL . This means that fields in filter must all be marked as External ID or have custom indexes created.

Failing that, one may want to use SOSL, because the search indexer (not to be confused with a database index) will include all of the filter fields in the search.





22 comments:

  1. Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support about this area.
    digital marketing training in marathahalli

    digital marketing training in rajajinagar

    Digital Marketing Training in online


    full stack developer training in pune


    full stack developer training in annanagar

    ReplyDelete
  2. Well researched article and I appreciate this. The blog is subscribed and will see new topics soon.
    python training institute in chennai
    python training in chennai
    python training in chennai

    ReplyDelete
  3. Resources like the one you mentioned here will be very useful to me ! I will post a link to this page on my blog. I am sure my visitors will find that very useful
    Blueprism training in Pune

    Blueprism online training

    Blue Prism Training in Pune

    ReplyDelete
  4. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Data Science Training in Chennai
    Data science training in bangalore
    Data science online training
    Data science training in pune

    ReplyDelete
  5. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..


    angularjs Training in chennai
    angularjs-Training in pune

    angularjs-Training in chennai

    angularjs Training in chennai

    angularjs-Training in tambaram

    ReplyDelete
  6. And indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.

    Best PHP Training Institute in Chennai|PHP Course in chennai
    Best .Net Training Institute in Chennai
    Big Data Hadoop Training in Chennai
    Linux Training in Chennai
    Cloud Computing Training in Chennai

    ReplyDelete
  7. It is a great post. Keep sharing such kind of useful information. oracle training in chennai

    ReplyDelete
  8. I read this post two times, I like it so much, please try to keep posting & Let me introduce other material that may be good for our community.

    ReplyDelete
  9. I read this post two times, I like it so much, please try to keep posting & Let me introduce other material that may be good for our community. data science courses

    ReplyDelete
  10. I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! data science training in mysore

    ReplyDelete
  11. Easily, the article is actually the best topic on this registry related issue. I fit in with your conclusions and will eagerly look forward to your next updates. data science training in surat

    ReplyDelete
  12. Your weblog is an inordinate measure of impeccable. i've noticed skillfully the thing I was looking. additionally, the substance energies is first rate. gratitude for the bump! IOS Data Recovery Torrent

    ReplyDelete
  13. Yet again yet again a couple of times, you can defer and restart exercises; the result results can be protected and imported, similarly as at whatever point you restart, there is compelling reason need to check. Easeus Data Recovery Wizard License Code

    ReplyDelete
  14. I have Been addressing pretty much this count number, as a final product gratitude for posting. cold publication.It 's as a matter of fact exceptionally fine and helpful say.thank you Happy Birthday Famous Quotes

    ReplyDelete
  15. Great post. keep sharing such a worthy information.
    AWS Training institute in Chennai

    ReplyDelete
  16. I was really impressed by this software. It gives me help in solving problems. that's nice.
    https://thepcsoft.com/anydesk-crack-latest/

    ReplyDelete

  17. "Appreciate the CRM insights – practical advice that's easy to follow.

    "getbound

    ReplyDelete