What conditions should be true for a table to consider search optimization

What conditions should be true for a table to consider search optimization
A . The table size is at least 100 GB
B. The table is not clustered OR The table is frequently queried on columns other than the primary cluster key
C. The table can be of any size

View Answer

Answer: A,B

Explanation:

Search optimization works best to improve the performance of a query when the following conditions are true:

For the table being queried: