In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3
A . Use intrisic functions in the WHERE clause
B . Use SELECT * to include all fields
C . Use Primary key(s) on fields used in joins
D . Use intermediate tables to stage data
E . Only update records that have changed since last execution

View Answer

Answer: C,D,E