COF-C02 · Question #354
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
The correct answer is D. Search optimization service. The search optimization service improves the performance of point lookup queries on large tables by using selective filters to quickly return a small number of rows. It creates an optimized data structure that helps in pruning the micro-partitions that do not contain the…
Question
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Options
- AAutomatic clustering
- BMaterialized views
- CQuery acceleration service
- DSearch optimization service
How the community answered
(18 responses)- C6% (1)
- D94% (17)
Explanation
The search optimization service improves the performance of point lookup queries on large tables by using selective filters to quickly return a small number of rows. It creates an optimized data structure that helps in pruning the micro-partitions that do not contain the queried values.
Topics
Community Discussion
No community discussion yet for this question.