Salesforce
PDII · Question #276
Users complain that a page is very slow to respond. Upon investigation, the query below is found to perform slowly. Which two actions can a developer take to improve performance? (Choose two.)
The correct answer is C. Add a LIMIT clause to the query to reduce the number of records returned. D. Contact Salesforce customer support to create a custom index to include null values. See the full explanation below for the reasoning.
Question
Users complain that a page is very slow to respond. Upon investigation, the query below is found to perform slowly. Which two actions can a developer take to improve performance? (Choose two.)
Options
- AMake the CustomField_c field an External ID.
- BMake the field CustomField_c required because Salesforce field indexes do not include nulls.
- CAdd a LIMIT clause to the query to reduce the number of records returned.
- DContact Salesforce customer support to create a custom index to include null values.
How the community answered
(23 responses)- A17% (4)
- B9% (2)
- C74% (17)
Community Discussion
No community discussion yet for this question.