Which two areas should a Data Architect investigate during troubleshooting if queries are timing out?

A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)
A . Make sure the query doesn’t contain NULL in any filter criteria.
B. Create a formula field instead of having multiple filter criteria.
C. Create custom indexes on the fields used in the filter criteria.
D. Modify the integration users’ profile to have View All Data.

View Answer

Answer: A,C