Activity Forums Salesforce® Discussions What is the governor limits of sub query in SOQL?

  • saloni gupta

    Member
    July 13, 2017 at 12:38 pm

    In the nested query, what is the Salesforce governor limits of sub query in SOQL?

  • Aman

    Member
    July 13, 2017 at 1:39 pm

    Hello Saloni,

    In a SOQL query with parent-child relationship subqueries, each parent-child relationship counts as an extra query. These types of queries have a governor limit of three times the number for top-level queries. The row counts from these relationship queries contribute to the row counts of the overall code execution.

    • This reply was modified 4 years, 4 months ago by  Aman.
  • Radhakrishna

    Member
    July 14, 2017 at 10:39 am

    Hello Saloni,

    By using below points you can understand Salesforce governor limits of sub query in SOQL:

    In a SOQL query with parent-child relationship sub-queries, each parent-child relationship counts as an additional query. These types of queries have a limit of three times the number for top-level queries.

    The row counts from these relationship queries contribute to the row counts of the overall code execution.

    In addition to static SOQL statements, calls to the following methods count against the number of SOQL statements issued in a request.

    Database.countQuery
    Database.getQueryLocator
    Database.query
    From above statement i can clarify one point:

    For example your org contain  only 2 Account and each have 10 Contacts.

    If you execute this with sub Query like below

    Select Id, Name, (Select Id, Name from Contacts) From Account

    Then the total number of Query rows will be 22 (2+10+10).

    From above analogy we can understand like this

    If your org contain 40M accounts and each have 1 contact.

    Then in this scenario you can use sub query up to 25M only.

    Like this Select Id, Name, (Select Id, Name from Contacts) From Account limit 25M

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

    • This reply was modified 4 years, 4 months ago by  Radhakrishna.
  • Parul

    Member
    September 19, 2018 at 6:30 pm

    Adding some points:

    In a SOQL query with parent-child relationship sub-queries, each parent-child relationship counts as an additional query. These types of queries have a limit of three times the number for top-level queries.

    The row counts from these relationship queries contribute to the row counts of the overall code execution.

    In addition to static SOQL statements, calls to the following methods count against the number of SOQL statements issued in a request.

     

    Database.countQuery
    Database.getQueryLocator
    Database.query
    From above statement i can clarify one point:

     

    For example your org contain  only 2 Account and each have 10 Contacts.

     

    If you execute this with sub Query like below

    Select Id, Name, (Select Id, Name from Contacts) From Account

     

    Then the total number of Query rows will be 22 (2+10+10).

     

    From above analogy we can understand like this

     

    If your org contain 40M accounts and each have 1 contact.

    Then in this scenario you can use sub query up to 25M only.

     

    Like this Select Id, Name, (Select Id, Name from Contacts) From Account limit 25M

     

    Thanks

  • shariq

    Member
    September 19, 2018 at 10:54 pm

    Hi,

    Note - Each parent-child relationship adds up to  an additional query.

    Hope this helps.

Viewing 1 - 5 of 5 posts

Log In to reply.

Popular Salesforce Blogs