pdii question 395 discussion

Question 395

Consider the following code snippet:

The Apex method is executed in an environment with a large data volume count for Accounts, and
the query Is performing poorly.
Which technique should the developer Implement to ensure the query performs optimally, while
preserving the entire result set?

• A. Annotate the method with the @Future annotation.
• B. Create a formula field to combine the CreatedDate and RecardType value, then filter based on the formula.
• C. Use the Database.queryLocator method to retrieve the accounts.
• D. Break down the query into two individual queries and Join the two result sets.