The data architect for Universal Containers has written a SOQL query that will return all records from the Task object t
Posted: Thu Apr 06, 2023 1:23 pm
The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field:
SELECT ID, Description, subject FROM Task WHERE WhatID != NULL
When the data architect uses the query to select values for a process, a time-out error occurs.
What does the data architect need to change to make this query more performant?
A. Change the WHERE clause to filter by a deterministic defined value.
B. Change query to SOSL.
C. Remove description from the requested field set.
D. Add LIMIT 100 to the query.
SELECT ID, Description, subject FROM Task WHERE WhatID != NULL
When the data architect uses the query to select values for a process, a time-out error occurs.
What does the data architect need to change to make this query more performant?
A. Change the WHERE clause to filter by a deterministic defined value.
B. Change query to SOSL.
C. Remove description from the requested field set.
D. Add LIMIT 100 to the query.