Which Best techniques she should consider here?

Melissa, Senior Data Engineer, looking out to optimize query performance for one of the Critical Control Dashboard, she found that most of the searches by the users on the control dashboards are based on Equality search on all the underlying columns mostly.

Which Best techniques she should consider here?
A . She can go for clustering on underlying tables which can speedup Equality searches.
B . A materialized view speeds both equality searches and range searches.
C . The search optimization service would best fit here as it can be applied to all underlying columns & speeds up equality searches. (Correct)
D . Melissa can create Indexes & Hints on the searchable columns to speed up Equality search.

View Answer

Answer: C

Explanation:

Clustering a table can speed any of the following, as long as they are on the clustering key:

・ Range searches.

・ Equality searches.

However, a table can be clustered on only a single key (which can contain one or more columns or expressions).

The search optimization service speeds equality searches. However, this applies to all the columns of supported types in a table that has search optimization enabled. This is what required here& best fit for purpose.

A materialized view speeds both equality searches and range searches, as well as some sort opera-tions, but only for the subset of rows and columns included in the materialized view.