I am trying to execute the following SOQL query to count number of notes in Salesforce instance:
SELECT Count(Id) notes_count FROM Note over the API.
OPERATION_TOO_LARGE: exceeded 20000 distinct ids error as a response.
- why I am seeing this response (i.e. I have previously made counts of notes where result was much larger than 20000 notes)?
- How can I fix my count query to overcome this?