What is the advantage of using materialized views in watsonx.data for frequently executed aggregate queries?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Materialized views persist pre-computed aggregation or join results; dashboard queries hit the smaller materialized result set instead of scanning millions of rows in base tables; trading storage for dramatically improved latency.
Full explanation below image
Full Explanation
Materialized views persist pre-computed aggregation or join results; dashboard queries hit the smaller materialized result set instead of scanning millions of rows in base tables; trading storage for dramatically improved latency. The incorrect options ("Materialized views prevent other users from querying the underlying base tables", "Materialized views automatically update in real time as new data arrives via Kafka", "Materialized views compress base table data to reduce storage costs") are distractors that don't fully capture the concept described.