Consider the following queries. For these queries, assume that there are more than 200,000 Account records. These records include soft-deleted records; that is, deleted records that are still in the Recycle Bin. Note that there are two fields that are marked as External Id on the Account. These fields are Customer_Number＿c and ERP_Key＿c. Which two queries are optimized for large data volumes? (Choose two.)

A. SELECT Id FROM Account WHERE Name != '' AND IsDeleted = false
B. SELECT Id FROM Account WHERE Id IN :aListVariable
C. SELECT Id FROM Account WHERE Name != '' AND Customer_Number＿c = 'ValueA'
D. SELECT Id FROM Account WHERE Name != NULL

Suggest answer: BC

Reference:

No comments:

Please share to make the community better.