Search optimization works best to improve the performance of a query when the following conditions are true: [Select All that apply]

Search optimization works best to improve the performance of a query when the following conditions are true: [Select All that apply]
A . The table is not clustered.
B . The table is frequently queried on columns other than the primary cluster key.
C . Search Query uses Equality predicates (for example, <column_name> = <constant>) OR Predicates that use IN.
D . Search Query uses Sort Operations.

View Answer

Answer: A, B, C

Explanation:

Materialized Views works best for search query performance in case of Sort Operations. For Rest of the points Search optimization works best to improve query performance.