Tagged: Limits in Salesforce, Salesforce SOQL, Salesforce SOSL, SOQL, SOQL query, SOSL, SOSL Query
- April 9, 2018 at 9:01 am #27332
What is the maximum number of rows that SOQL and SOSL can “scan”?
What is the maximum number of rows that SOQL and SOSL can “scan”?
Tagged: Limits in Salesforce, Salesforce SOQL, Salesforce SOSL, SOQL, SOQL query, SOSL, SOSL Query
April 9, 2018 at 11:02 am #27349Hi,
LIMIT is an optional clause that can be added to a SOSL query to specify the maximum number of rows that are returned in the text query, up to 2,000 results. If unspecified, the default is the maximum 2,000 results. The default 2,000 results is the largest number of rows that can be returned for API version 28.0 and later.
The LIMIT clause has no limit in and of itself. It’s limited to the context in which it’s used. If it’s used in Apex code it’s limited to the total governor limit for SOQL rows, which is currently 50,000. If it’s used in a query via the Web Service API then there is no limit.
Hope this helps you.
April 10, 2018 at 2:12 pm #27404 - AuthorPosts