Choose the different ways that you have to optimize query performance

Choose the different ways that you have to optimize query performance
A . Clustering a table
B. Creating one or more materialized views
C. Search Optimization
D. Vacuuming

View Answer

Answer: A,B,C

Explanation:

Please note that search optimization is still in preview mode. But this will be a powerful feature to optimize your query. If you are in a Snowflake implementation project, you must evaluate this feature. The current disadvantage is that when you apply search optimization, it creates an index for all the applicable columns in the table, you cannot specify a certain column to be indexed. So, you do not have a way to reduce your index size by selecting only certain columns. Good news is that from my experience, I have seen that only 10% of the overall data size is used for the index. Considering Other Solutions for Optimizing Query Performance

The search optimization service is one of several ways to optimize query performance. Related techniques include: