Activity Forums Salesforce® Discussions What is the best way to query big objects

  • What is the best way to query big objects

    Posted by Shweta on October 29, 2020 at 11:50 am

    What is the best way to query big objects if you're working with an extremely large set of data?

    Marziya replied 4 years ago 3 Members · 2 Replies
  • 2 Replies
  • Anjali

    Member
    October 29, 2020 at 12:51 pm

    Async SOQL is the most efficient way to process the large amount of data in a big object.

  • Marziya

    Member
    October 29, 2020 at 1:00 pm

    To retrieve millions and millions of potential records from custom Big Objects, Async SOQL can be used. It can run queries that normally time out with regular SOQL. Multiple queries can run in the background and updation of completion status can be monitored. Async SOQL is the best way to query huge amount of data.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos