What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object?

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year.

What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers
A . Use SOQL queries without WHERE conditions.
B . Work with Salesforce Support to enable Skinny Tables.
C . Reduce the number of triggers on Order _c object.
D . Make the queries more selective using indexed fields.

View Answer

Answer: B,D