How should clustering be used to optimize the performance of queries that run on a very large table?

Question

Options

• AManually re-cluster the table regularly.
• BChoose one high cardinality column as the clustering key.
• CUse the column that is most-frequently used in query select clauses as the clustering key.
• DAssess the average table depth to identify how clustering is impacting the query.

• A
  3% (2)
• B
  86% (50)
• C
  2% (1)
• D
  9% (5)

Explanation

For optimizing the performance of queries that run on a very large table, it is recommended to choose one high cardinality column as the clustering key. This helps to co-locate similar rows in the same micro-partitions, improving scan efficiency in queries by skipping data that does not match filtering predicates.

No community discussion yet for this question.