Users complain that a page Is very slow to respond. Upon investigation, the query below Is found to perform slowly.
SELECT id, Name FROM Contact WHERE CustomField_c null;
Which two actions can a developer take to improve performance?
Choose 2 answers

Question

Users complain that a page Is very slow to respond. Upon investigation, the query below Is found to perform slowly.

SELECT id, Name FROM Contact WHERE CustomField_c null;

Which two actions can a developer take to improve performance?

Choose 2 answers

Salvatore Buscio · Accepted Answer

Add a UMir dause to the query to reduce the number of records returned.

Salvatore Buscio · Accepted Answer

Make the field CustomReW__c required because Salesforce field Indexes do not Include nulls.

Salvatore Buscio · Answer

Contact Salesforce customer support to create a custom index to include null values

Salvatore Buscio · Answer

Make the CustomFleld__c field an External ID.

List of questions