There is a long-running query that selects everything and runs arithmetic calculations on a few columns in a table that does not change often. Which action will improve the performance of this query?
A.
Enable Query Acceleration Service on the virtual warehouse.
A materialized view stores precomputed results and is useful when a query is repeated and the underlying table does not change often. Since the query runs calculations on a stable table, materializing the result can reduce repeated computation.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit