A company has a very large table that is being queried by two groups. Each group uses unique WHERE clauses in their queries. The first group consistently achieves high-performance results, while the second group experiences poor query performance. Analysis of the Query Profile reveals that the first group’s queries access a limited number of micro-partitions, in contrast to the second group’s queries that scan all micro-partitions in the table. What should be done to ensure that performance is MAXIMIZED for both sets of queries?
Select one answer.
Purchase Full Access to view answer options & explanation
The first 60 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 198 questions.
