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.

Answer: A,C

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments